Hide every field and record , until combo box selection is made.

[birpal]

Hi, made an form in Access that has a Combo box, ole image and about 22 text fields. I would like to hide the text fields and image until a coressponding selection is made in the combo box.

[pbaldy]

Here's the basic method:

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

With that many controls, I'd probably loop the controls and use the tag property to determine which to hide/show.

[birpal]

How would i go about that - I am very new to Access and each of my fields is linked to the same table and by record in my form.

Can you tell me in a few steps how and where I would write the code?

Please and thank you.