Form Fields tied to Autonumber in tables, instant generation?
Posted on 1998-05-04
With a relational database and referential integrity enforced, a form can reference data from more than one table. If these tables have an Autonumber as primary key, it seems that as soon as one field from that table is entered on the form, an Autonumber generates. Thus, if I want to clear the form, I have already used one of the numbers in sequence. Is there a way to unbound the form or do I need to unbind each field individually? Should I change the primary key to an integer and increment it by one myself with VBA? Summarily, how can I make the form save the data only when I advance to the next screen or press a save button?