Autonumber

H

Hong

I have two querries from one table, and each querry create different form.
In this table have autonumber, how can I create the form share the
autonumber, for example, enter data into each form, will add the data into
table follow the autonumber.

Thanks
 
K

Klatuu

Queries do not create forms. Forms can have either queries or tables as
their record source. When you create a new record using a form, it adds the
record to the table that is the origin of the data. If you are using a
query, the record will be added to the table the query is based on. So it
does not matter which form you use or even if you add a record directly into
the table, the autonumbering will take care of itself. That is what
autonumbers do. Regardless of how a record is added, it will create a new
unique autonumber on its own.
 
Top