allow\disallow

[herbert]

Hi Guy's i am using access 2003, on my form ,i have
textboxs and comboboxes, if there is an entry in one
special text box, i want to disallow entry in the combobox
, and vices\versa ,
i am just a novice so could some one list the steps to do
this in a macros or VB
thanks
herbert

 

[Ed Robichaud]

You can use the Visible or Enabled property of your combobox to restrict its
use, and control it through the AfterUpdate event of your text control. Use
something like:

If IsNull(Me![myTextbox]), Then
Me![myCombo].Visible = True
Else
' if anything entered into the text box then make the combo
invisible to prevent entry into it
Me![myCombo].Visible = False
End If

-Ed