G
Guest
I'm trying to create a form for data entry purposes. I have a numeric field
in the database called invoice_ID. I would like to pre-fill the Invoice_Id
field in the form with the highest invoice_ID in the database + 1. I have a
query defined (Max_ID) that selects the max id (as ID) already in the
database. When designing the form, I enter "=[Max_ID]![ID]+1" as the default
in the properties window for the field linked to Invoice_ID. This results in
an error and I can't figure out why. Any help would be greatly appreciated.
in the database called invoice_ID. I would like to pre-fill the Invoice_Id
field in the form with the highest invoice_ID in the database + 1. I have a
query defined (Max_ID) that selects the max id (as ID) already in the
database. When designing the form, I enter "=[Max_ID]![ID]+1" as the default
in the properties window for the field linked to Invoice_ID. This results in
an error and I can't figure out why. Any help would be greatly appreciated.