Form / Subform Problem

[aneats]

I have created a tabbed form, based on a multi-table query, with 4 subforms in it. Application is the main table in the db, with the primary key,id, being an autonumber and all other tables are related to this table via the id field, which is a number field.
For each new record i create, there is a corresponding id (coming from the application id autonumber) which is stored in each of the relating tables. As i fill out the fields in my form, there doesn't seem to be a problem, not until i move the cursor into the 2nd tab, and 2nd subform, when i get a message "You cannot add or change a record because a related record is required in the table 'Application'.

Would be grateful if anyone could help with this!!

 

[ehdoh]

I'm no expert in Access but have recently set up a database that sounds similar to yours.

Have you checked to see that you have relationships created between the ID fields in the different tables? Perhaps you wouldn't need to set this up if what you're entering is based on queries.

The only other thing I know to check would be the link child/master fields in the properties box of the main form.

Good luck!
E.

 

[aneats]

Thanks for your suggestion, however i have already implemented the things you suggested, and i still get the same problems.
I have checked the form to the extent that i know the problem lies with the subforms and not the underlying query.
I can enter data into the first subform, in the first tab, and when i enter the second tab and try to enter data into the second, third or forth subform, i am having a problem with an error message (previously posted) appearing each time.

could someone please help as the deadline for completion of this database is imminent!!!!!

thankyou.

 

[aneats]

I managed to get this problem sorted out. Thanks anyway.