allow\disallow

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

herbert - 18 Apr 2005 11:14 GMT

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

Reply to this Message

Ed Robichaud - 18 Apr 2005 13:33 GMT

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

> Hi Guy's i am using access 2003, on my form ,i have
> textboxs and comboboxes, if there is an entry in one
[quoted text clipped - 4 lines]
> thanks
> herbert

Reply to this Message