Hi guys
First time poster here!
I used to be quite good at access, but just having another go after many years of not using it. Hopefully this isn't a difficult one..
In a form (Contact Details)
I have a combo box with a value list (Access type) - the list being Type A and Type B.
Then I have the following fields
Type A IP Address
Type A UserID
Type A Password
Type B UserID
Type B Password
My question is this...
When Type A is chosen in Access Type,
I want the user to enter details in
Type A IP Address
Type A UserID
Type A Password
But not in the Type B UserID, or Type B Password fields
When Type B is selected in Access Type
I want the user to enter details in
Type B UserID
Type B Password
Is there a way of hiding or greying out the fields I don't want them to type in?
Your help with this is really appreciated.
Thanks
First time poster here!
I used to be quite good at access, but just having another go after many years of not using it. Hopefully this isn't a difficult one..
In a form (Contact Details)
I have a combo box with a value list (Access type) - the list being Type A and Type B.
Then I have the following fields
Type A IP Address
Type A UserID
Type A Password
Type B UserID
Type B Password
My question is this...
When Type A is chosen in Access Type,
I want the user to enter details in
Type A IP Address
Type A UserID
Type A Password
But not in the Type B UserID, or Type B Password fields
When Type B is selected in Access Type
I want the user to enter details in
Type B UserID
Type B Password
Is there a way of hiding or greying out the fields I don't want them to type in?
Your help with this is really appreciated.
Thanks