allow\disallow

  • Thread starter Thread starter herbert
  • Start date Start date
H

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
 
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
 
Back
Top