Combo Box to change fields

[Guest]

Hi!
Is it possible to create a combo box which changes the other fields
according to the selection made in combo box on a form.
For example, if user selects 'Monitor', other fields such as 'flat
screen/CRT?' would appear. However, if user selects 'Mouse', the previous
fields would disappear and 'optical?' would replace it.
If it is possible, i would really appreciate some steps so i can have a go.

many thanks

 

[Guest]

When you say "fields" I assume you mean the combo option list? It is called
a cascading combo.

 

[BruceM]

What exactly do you mean by "other fields ... would appear"? Appear in text
boxes? Appear in a drop-down list?

 

[Guest]

Other fields would appear in the form according to a selection in a combo box

 

[Guest]

So you want to make the fields visible?

Put this in the after update event of the combo

If [combo box value] = "whatever" then [fieldname].visible = true

 

[BruceM]

Except that fields to not have a visible property. However, the visible
property can be applied to controls. If the OP used the Access default of
using the same name for a field and the text box bound to that field, I
think the Access can sort it out and apply the Visible property to the
control.
To the OP, scubadiver has answered your question in one sense, but remember
that we cannot see your database, and we do not know what exactly you need
to do. What is the relationship between the controls you would make visible
and the selection in the combo box? If a combo box selection renders the
controls visible or invisible, do you want them to remain that way as you
navigate through the records.

So you want to make the fields visible?

Put this in the after update event of the combo

If [combo box value] = "whatever" then [fieldname].visible = true



--

http://www.ready4mainstream.ny911truth.org/index.html

Other fields would appear in the form according to a selection in a combo
box