Can you please advise on the following?
When saving a record from a user form, I would like the form to reopen again viewing the record that has just been saved by the user.
When I save a record, the userform closes as this triggers the requerying of the tables etc.
There are multiple users of the dbase feeding into the backend so what I specifically need is to obtain the last unique record id (BusinessID) created by the current user?
For example: UserID MXON01 creates a new record with a unique BusinessID of 234.
As there are multiple users feeding into a backend at the same time, using the
would not be appropriate.
Any suggestions would be much appreciated.