Forms Updating Tables

  • Thread starter Thread starter Stacy Farmer
  • Start date Start date
S

Stacy Farmer

I have several tables updating from a bid proposal form.
The problem is when you go into the form, first field is
autonumber, autonumber is the relationship key to 4
tables, the problem is, when you open the form and decide
to get out without entering a record, it uses the
autonumber form in one table, but not the other tables,
therfore confusing the relationship, any help would be
appreciated, such as: can I assign the autonumber after
upon accepting the input?
Thanks
Stacy
 
If you are setting field values via code on form open, then the form is
going to think that a new record has been added and automatically try to
save that record on form exit. If you do not see (AutoNumber) in the
corresponding field on the form, then something is getting put in the
current record.

HTH
Kat
 
Back
Top