I have a form on which the operator inputs the required information.
On clicking the 'upload record' button, code runs to open a recordset of the data table and update the information from the fields on the form.
I have 2 problems.
1.I also want this action to generate the next reference number in the database.
2.I need the format of the number to be yyyy-###,
eg 2001-001 and so on. What properties should I give this field in my table?
Thanks in advance.
Lloyd Gozzett
Process Developer
On clicking the 'upload record' button, code runs to open a recordset of the data table and update the information from the fields on the form.
I have 2 problems.
1.I also want this action to generate the next reference number in the database.
2.I need the format of the number to be yyyy-###,
eg 2001-001 and so on. What properties should I give this field in my table?
Thanks in advance.
Lloyd Gozzett
Process Developer