Subform Help

[ChrisDo11]

My main form automatically assigns each record an ID(autonumber), if info is entered into any of the subforms the subforms take on this same ID as the main form(Dlookup).

when i exit the form and re-enter to start a new record the main form starts a new record, but any subforms show the last entered record which then overwrites that record in the table.

ie). Main Form: Record1 SubForm: Record1
Record2
Record3

Then I exit and re-enter the form which shows;

Main Form: nothing SubForm: Record3

If i enter info into the main form, record3 updates to match this new record and overwrites the original record3.


i hope this makes sense and that someone knows a solution....

Thanks,

 

[DES]

Sure do:

The problem is that you should not be using a DLookUp to assign the values to the sub forms. Instead you need to link the sub forms to the master form.

This is done on the data tab for the sub form "Link Master Fields" and "Link Child Fields"

Email me a sample if you can not do it and I will get it done for you.

DES