Force cursor to next field
Thank you for your previous help. I am learning more all the time. (PS, I have not taken any classes on Access, so I turn to this forum for help)
I have created a form for entering jobs into our database. All of the fields are âLockedâ âOn Currentâ if there is not a âTWOrderNumberâ present.
Me.Customer.Locked = True
Me.PartNumber.Locked = True
Me.Customer.Locked = False
Me.PartNumber.Locked = False
I have locked the fields to prevent data entry until the âNew Work Orderâ command button is clicked. When the âNew Work Orderâ button is clicked, a âTWOrderNumberâ is generated and all of the data entry fields are unlocked.
I would also like to write the code to make the cursor go to the âCustomerâ text box when the command button âNew Work Orderâ is clicked. The âCustomerâ text box is tab stop â 2 on the form. The âCustomerâ field would be the 1st field data will be entered in.
Thanks in advance for any help.