Navigation between subforms on a form

D

dvw

I have a form with two subforms. I don't seem to be able to exit properly
from the first subform to go to the second subform, and (I think) thats why
when I go to close the main form after my data entry is complete I'm getting
the error message that I can't have a null value in a key or index field. I
only want to enter data for one record in the first subform, then go to the
second subform but the tab key just keeps wanting to add data for more
records in the first subform. I guess my question is how do I correctly exit
the first subform to go to the second one?
I should add there are only two tables in this database- both subforms are
trying to update parts of the one table. TIA
 
Top