Changing fields based on selection

[collegeprodigy]

I have a form with a list box that has two values. For whichever value is selected, I want a different set of fields to pop up. How do I do that?

 

[mark curtis]

have a look at attached

 

[saharlan]

Hope this helps

In the "on open" event of your form set up an event procedure which sets all the fields you want to turn off and on by using the .visible method.

example... yourfieldsname.visible = true or false

then in the update event of your listbox set up an event procedure which makes the fields you want visible = true

example... if list35 = "credit" then
creditcardnumber.visible = true
cardtype.visible = true
authNumber.visible = true
paymentamount.visible = true
.
elseif List35 = "check" then
checknumber.visible = true
paymentamount.visible = true
end if

Hope this helps...

 

[collegeprodigy]

That helps, but how would I do that same thing in a subform?

Thanks saharlan.