Hey Guys,
I am Jason, a new member of the forum.
I have a small problem.
As it relates to Dmax functions. I am doing an invoicing database and would like to know how I can leverage the use of the Dmax function to automatically generate invoice numbers when a user opens the invoice form to create an invoice.
The database is split. The table in the back end is called tbl_invoiceregister and the form is called frm_invoiceentry. There is the "invoice nmbr" field on the form that is linked directly to the table.
I would like the database to populate this field with the next available invoice number whenever someone opens the invoice entry form to create an invoice.
Kindly assist on the coding and exact directions on where I should place this code to get the desire effects.
It would be greatly appreciated.
Regards
I am Jason, a new member of the forum.
I have a small problem.
As it relates to Dmax functions. I am doing an invoicing database and would like to know how I can leverage the use of the Dmax function to automatically generate invoice numbers when a user opens the invoice form to create an invoice.
The database is split. The table in the back end is called tbl_invoiceregister and the form is called frm_invoiceentry. There is the "invoice nmbr" field on the form that is linked directly to the table.
I would like the database to populate this field with the next available invoice number whenever someone opens the invoice entry form to create an invoice.
Kindly assist on the coding and exact directions on where I should place this code to get the desire effects.
It would be greatly appreciated.
Regards