on my form i need a new id.
the new id is set in a textbox using =MaxPID() set in the textbox's Default Value.
MaxPID() executes a query the last Id from my table + 1. i use this for my new id.
After i execute my insert query on this form, how can i refresh my form and set my new id ( the most recent id+1 ) ?
the new id is set in a textbox using =MaxPID() set in the textbox's Default Value.
MaxPID() executes a query the last Id from my table + 1. i use this for my new id.
After i execute my insert query on this form, how can i refresh my form and set my new id ( the most recent id+1 ) ?