Macros to Add/Edit data when form opens

**PianoMan64** · Nov 10 '08, 03:03 AM

Originally posted by lchomany

Good Day!
I have a macro created to Open my subform and is embedded in the Command Button.
Main Form: frmADD NEW ENTITY NAME
Subform: frmEntityAwards

My macro filters to the specific EntityID and I can view the awards to the particular Entity as follows [EntityID]=[Forms]![frmADD NEW ENTITY NAME]![EntityID]

Now I want to Edit and/or ADD a new Award. Currently it won't let me add anything and I have no locks and everything is set to Edit Data, etc. in the property sheet.

Please help me with the next actions in my macro

Thank you so much!!!

Hello lchomany,

From what you describe, it sounds like you have your relationships between the main form and the subform messed up in such a way that it is preventing you from adding any additional information to the tables.

If you can post your table structure, including field types, and size, as well as any relationships between the tables. You also would have to post any detail settings that you setup on the form that you're using to relate the main form to the sub form. if you're currently using a primary key from the parent table with linking value in the child table.

I would need to know all that in order to troubleshoot any of the problems that you're having.

I would also suggest that you include in your post a copy of the macros that you're currently using and also describe what you are seeing as well as what you're trying to achive.

Hope that helps,

Joe P.

Macros to Add/Edit data when form opens

Macros to Add/Edit data when form opens

Comment