Form problem

[m17347047711116]

Have a form with several fields within, would like all fields to be unavailable for entry until the first required field is complete.

[Department]
[Job]
[Classification]

Would like to have no access to [Job] or [Classification] until [Department] field is completed.

 

[trucktime]

Fields

Put the following code in the On Current Event of the form:

If IsNull(Me.Department) Then
Me.Job.Enabled = False
Me.Classification.Enabled = False
Else
Me.Job.Enabled = True
Me.Classification.Enabled = True
End If

 

[MarkK]

Also,

Me.Job.Enabled = Not IsNull(Me.Department)
Me.Classification.Enabled = Me.JobEnabled