disable text box in subform

[Guest_imported]

i have a form named Customers and a sub form named Details and a combo box in subform named Combo1

How can i Disable the Combo1 By VBA Code?
thanks

 

[pjm]

Hi

Forms!Customers!Details!Combo1.Enabled = False

(You'll get an error if the combo has the focus so set the focus to something else beforehand.)

HTH
pjm

 

[Guest_imported]

i set the focus to another control in the form but the error is : Can't move the focus to that control

why?

 

[THoey]

Is the subform visible at that time? Terry M. Hoey

 

[pjm]

What kind of control are you trying to set the focus to and what are its properties?

(It must be visible and enabled and not something like a label that can't get the focus.)

pjm