Disabling controls on a form

  • Thread starter Thread starter A
  • Start date Start date
A

A

I am trying to disable some controls on a form based on the selection the
user makes from a combo box field.

The combo box field is named Order, there are two options "Takeaway" and
"Dining In"

If "takeaway" is selected i want the following controls disabled:
TableNo
Covers
CmdBar
CmdKitchen
CmdBill

If "Dining in" is selected, i want the following controls disabled:
Status
CmdReport
TelNo
PickupTime

Any suggestions on how i could do this?

Thanks in advance

Pinky
 
select Case Me.ComboBox
Case "takeaway"
me.TableNo.enabled = false
:
Case "Dining In"
me.TableNo.Enabled = true
:
End Select




= "takeaway" then
 
Back
Top