1>Find the highest value assigned to the part # in the same table. This was done with another extra query.
a.QryMaxAGL
Expand|Select|Wrap|Line Numbers
- SELECT Max([TAGLserial].[AGLID]) AS AGLmax FROM TAGLserial;
3> Assign this value to one of the field in the table when the user add a new record.
In summary, I have used the following, but I can’t get it to work.
Expand|Select|Wrap|Line Numbers
- Me.text101= SELECT Max([TAGLserial].[AGLID]) AS AGLmax FROM TAGLserial;
control source = SELECT Max([TAGLserial].[AGLID]) AS AGLmax FROM TAGLserial;
Any comment would be greatly appreciated.