hiding field depending on selection of combobox (1 Viewer)

[tb5038]

Hi,

I have a form which has a combobox where the user selects a record from another table, this is linked (forgive me if my terminology is incorrect!)

I want to hide the forms fields [managercontact] and [managertelno] depending on the value of the combobox (manager) from the table details, but its not the value shown in the combobox its the value of another field [type] from the same table called details. Its one of two values being 'conc' or 'ob'.

I know my terminology is weak! Any questions please ask....

 

[pbaldy]

See if this gets you started:

http://www.baldyweb.com/ConditionalVisibility.htm

 

[Old Man Devin]

I would put some code in the After Update event of the combo box that checks what the value is and sets the visibility accordingly.

Using the code from the link above:

If Me.Manager = "Something" Then    
   Me.ManagerContact.Visible = False
   Me.ManagerTelNo.Visible = False
Else    
   Me.ManagerContact.Visible = True
   Me.ManagerTelNo.Visible = True 
End If