Link to home
Start Free TrialLog in
Avatar of Jegajothy vythilingam
Jegajothy vythilingamFlag for United States of America

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.
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jegajothy vythilingam

ASKER

thank u for the syntax
You're welcome.