Multiple Fields and Subforms

[Neil]

I have a multiple field subform with some combo boxs and
text boxes.

For the one record, I would like to make a user selection
in a combo box for one field make another field become a
combo box. These combo boxes just loop up tables.

Depending on what the user selects in the first combo
box, the other fields may or maynot become a combo box.

How can this be done?

 

[Mike Painter]

I have a multiple field subform with some combo boxs and
text boxes.

For the one record, I would like to make a user selection
in a combo box for one field make another field become a
combo box. These combo boxes just loop up tables.

Depending on what the user selects in the first combo
box, the other fields may or maynot become a combo box.

How can this be done?

I suspect the only way will be to have the text box and combo sitting on top
of each other and making the correct one visible.
Maybe not.
You could set the rows displayed to one and limit the recordsource to the
value you want.