Disabling a control

[NOTLguy]

On my form, I wish to disable one or two of three controls that follow the control I am in, depending on the selection made. The control I am in with the selection drop down is a is a lookup field from another table. This would prevent data entry in some of following three controls depending on choice from the first control. Is that possible?

Thank you,
Bill

[pbaldy]

This type of thing, using the Enabled property instead of the Visible property:

http://www.baldyweb.com/ConditionalVisibility.htm

[NOTLguy]

This type of thing, using the Enabled property instead of the Visible property:

http://www.baldyweb.com/ConditionalVisibility.htm

I tried to enter this code:

Private Sub CodeId_AfterUpdate()
If Hours.HoursId = 1 Then
Hours.Unreg.Enabled = False
End If
End Sub

in the Event Procedure for After Update and it bombed.

Error 424 Object Required.

The Control on the form I entered the code in is a lookup field in the Hours Table gathering data from another table ( Codes ) where the fields in the Lookup Query are in order of selection:

Codes.CodeId
Codes.CodeType
Codes.CodeDescription

presenting a pick list for the user.

Bill

[pbaldy]

Here's the proper syntax to refer to controls:

Forms Refer to Form and Subform properties and controls

[NOTLguy]

Here's the proper syntax to refer to controls:

Forms Refer to Form and Subform properties and controls

Once I gor the syntax correct, all was well.

Thank you,
Bill

[pbaldy]

Happy to help Bill.