Access Forms - Intelligent Combo box filtering

[nuffs3d]

Hi,

In my form I am trying to get a 2nd combo box to display a selection of data from my hardware table depending on the choice from the 1st combo box. For instance the first combo box is called Machine Type. If Laptop is chosen for this I would like the next combo box to only show laptops from which a further choice is made.

How is the is best achieved? Is there an online resource for this sort of access design...?

Thanks,

Si.

 

[PHV]

In the AfterUpdate event procedure of the first combo dinamically set the RowSource property of the second combo.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[nuffs3d]

That helps a bit but how do I dynamically set the row source property for the second combo? In the expression builder or a macro? If so what would I need the code to say?

Cheers,

Si.

 

[PHV]

Do a keyword search in this forum for cascading combo

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Xenos132]

Build a query and in the criteria field put [Forms]![Frmname]![BoxID]” Then have the second combo box use this query.

Then requery the 2nd box from the first.

Private Sub Combo26_AfterUpdate()
Me!Combo28.Requery
End Sub