Autonumber

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top