Jegajothy vythilingam
asked on
Outlook 2016 VB code syntax
My OS is win 10 pro 64 bit. I have Office 365 Business Essentials, and I use Access 2016. I have a application where I have a Form for data entry.
When the Form is opened, there is a command button, to add new record's ID, by taking the max number of the ID in the table, then adding 1 to it. The field is called ID. After this action, I would like the cursor to go to a Combo box, and the name of the field in the Form is Combo36. Please help me with the code syntax. The name of the Form is frmAllRecords.
I tried a DoCmd syntax but failed to get it right. Thank u for your suggestion.
When the Form is opened, there is a command button, to add new record's ID, by taking the max number of the ID in the table, then adding 1 to it. The field is called ID. After this action, I would like the cursor to go to a Combo box, and the name of the field in the Form is Combo36. Please help me with the code syntax. The name of the Form is frmAllRecords.
I tried a DoCmd syntax but failed to get it right. Thank u for your suggestion.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome.
ASKER