I had to transfer my Access database to a ODBC linked SQL database. Before this transfer, when the User entered data in the first applicable field on the form using AfterUpdate method, Access automatically displayed the auto number in the ID field. However, in SQL database the form must be saved or updated in the SQL database before the auto number ID can be determined. This is a multi-user database. I need to have the correct auto number displayed for the User at the time of data entry like it was when it was strictly an Access database. I tried letting the user choose a Saved button which does displays the new record with the auto number but the form does not stay on the screen long enough for the user to record the auto number.
The user needs to record the auto number for reference in future processing. If it must be after the User choose the Save Button then I need a way to keep the form on the screen or redisplay the correct auto number record in the form on the screen until the user decides he has recorded the number.
Can anyone help? Does anyone understand my dilemma?
Thanks for your help!
The user needs to record the auto number for reference in future processing. If it must be after the User choose the Save Button then I need a way to keep the form on the screen or redisplay the correct auto number record in the form on the screen until the user decides he has recorded the number.
Can anyone help? Does anyone understand my dilemma?
Thanks for your help!
