Is it possible to set up a conditional combo box in Access 97?

[Guest]

I'm attempting to set up an inventory database. I would like to create one
combo box for Computer Type (desktop, laptop, Apple/Mac workstation, Citrix
terminal) and then a second combo box (Computer Model) whose selection is
conditional based on the choice of the first combo box. If desktop is
selected in the first combo box, then the second combo box would contain a
list of desktop models. If laptop is selected, a different list of laptop
models would be available. Is this possible to set up in Access 97? Any
assistance is much appreciated.

 

[Al Camp]

mhmratech,
I have a sample file to show how to do this on my web site listed below.
It's in my Access Tips section under "Synched Combo Boxes" and it's an
A97 file.

 

[Pete]

Hello Al - many thanks - how about if you take it to another level?

- First add a new table for "country"
- Add a new form for Country
- Make the existing state / city form a sub form on the country form
- So now there is one detail line for every state in the country (consisting
of the existing two combo boxes)

Currently, you reference the first combo box in the lookup for the second
using [Forms]![frmSynchCombos]![cboState]

I tried expanding to [Forms]![frmCountry]![frmSynchCombosSubForm]![cboState]

But it seems that when there are multiple detail lines, each containing
combo boxes (the second to reference the existing choice in the first) - the
lookup for the second combo box column on the sub form seems to be run only
once when the form opens and applied to all combo boxes in the column.

Any thoughts on getting the desired behavior when the combo box is
replicated for many records in a detail section?
Thanks!
Pete.