Hi all,

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.

If IsNull(TWOrderNumber)
        Me.Customer.Locked = True
        Me.PartNumber.Locked = True
        SoOnAndSoForth
    Else
        Me.Customer.Locked = False
        Me.PartNumber.Locked = False
        SoOnAndSoForth
    End If

End Sub

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.


D. Bartelt

__________________
D. Bartelt

Use the .SetFocus method, i.e.

Me.Customer.SetFocus

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Mr. Serrano,

Thank you for your response. That was easy. I appreciate your help. My family and I will be vacationing near Traverse City beginning July 02, 2005. Love Michigan

Have a good day!

Don Bartelt

D. Bartelt