Adding New Records using Forms/Subforms

[Tammy]

I have several forms in my application which contain subforms in datasheet view. The subform contains the records queried from a table and the master form contains the subform and two command buttons which are suppose to allow you to add or delete a record in the subform however I don't know how to reference the subform as the object I want to add the record to. I used the command button Record Navigation code but this is meant to be used with the master form not the subform and when I tried adding the subform as Object Name to the code it said that the subform was not open and adding a new record is not possible. Any suggestions what to do now? I don't want to see the subform in any other way than as it is displayed in datasheet view on the master form. Thanks in advance for any help you can give.

 

[Carol]

As long as your datasheet is set to Edit Records, Add Records, and Delete Records you should be able to do so as long as it has the focus. Your problem lies within your query and your relationship. Go into your query set up and check out the relationships between the other tables/queries used.. To do this, highlight the join and click on Edit.
Good Luck