Combo only shows first record

[Steven811]

Hi

I've created 2 cascading combo boxes and they work okay with the exception that child only shows the first record.

The select query I'm using is as follows:

(I'm not sure if it's this)

[SELECT [qryAllCust].[CustKey], [qryAllCust].[CompanyName] FROM qryAllCust WHERE ((([qryAllCust].[CustKey])=[Forms]![forCascTest]![cboRep])) ORDER BY [qryAllCust].[CompanyName];]

Brains even more deathan ever today and I can't work it out.

Thx

Steven811

 

[llkhoutx]

Probably, there's only one record that correspondes to your filter: [qryAllCust].[CustKey])=[Forms]![forCascTest]![cboRep]

 

[Steven811]

More than one record should display

Hi

When I run a select query more than one record shows. When I run the combo query only one record is displayed. Very odd, it's something simple I'm sure.

Steven811

 

[llkhoutx]

On the AfterUpdate of the first, requery the second.