Query Criteria

[Khalil Handal]

Hello,



A combo box cboSetionType on a form HEADER has a Row Source using a select statement having two field: the primary key and the section value (A, B, C,...). The combo box shows only the section and hides the primary key.

A second combo box on the DETAIL section has a select statement for the row source. It shows all the records.
Is it possible to add a criteria so it will show records of a specific section selected from the first combo box in the Header area of the main form?

I tried the following criteria but was not successful.
Like [Forms]![frmSections]![cboSectionType]

frmSections is the name of the form.
cboSectionType is the name of the combo box on the header area of the form.


Any ideas?

Khalil

[Minty]

This sounds like you need what is often referred to as cascading combo's.
Paul has a great little guide here http://baldyweb.com/CascadingCombo.htm

[CJ_London]

Sql to your detail section combo would be something like

Select Id, description
From mytable
Where somefield=[cbosectiontype]

And in your header combo after update event some code along the lines of

Mydetailcombo.requery

[Khalil Handal]

Thank you both,
Managed to get it working