Can I use a combo box to display or add different information?

[Guest]

My questions are linked:

If I have a combo list, say of car models and I want to display information
for each model in a form: Model, engine capacity, year and fuel type for that
model, then select a select a different model, and the details change, is
this possible? How would I do this?

Secondly, if I want to capture both home and work address information
through a form, I would like to be able to click an option via a combo box to
select the home - enter the data, select work - enter the data. This way I
would obviously save display space. Is this possible? Again how would I do
this?

All help would be appreciated.

 

[Marshall Barton]

If I have a combo list, say of car models and I want to display information
for each model in a form: Model, engine capacity, year and fuel type for that
model, then select a select a different model, and the details change, is
this possible? How would I do this?

Secondly, if I want to capture both home and work address information
through a form, I would like to be able to click an option via a combo box to
select the home - enter the data, select work - enter the data. This way I
would obviously save display space. Is this possible? Again how would I do
this?

When you add a combo box to your form's header section, the
combo box wizard provides an option to find a matching
record.

Use the button's Click event procedure to make the other
address text box invisible. The code would be something
like:
Me.txtworkaddr.Visible = True
Me.txthomeaddr.Visible = False
Use the opposite settings for the other button.

 

[Guest]

Thanks Marshall, I will try this out - this is a bit new to me so I'll
probably play around for a bit till I get it right. I'll let you know.

Alastair