Combo Box Filter

[Bob Vance]

On my form I have a Combo Box "cbDailyRate" that has the query controlling
it, The Query has the field "HorseID" , How can I get the Combo/Query to
filter the relevant records to The same HorseID that is in the first column
of cbHorseName

 

[Arvin Meyer MVP]

I have a sample file that shows how to filter 1 list box from another, then
filter the form based upon the second. It does a little more than what you
want, but should serve as a good example:

http://www.accessmvp.com/Arvin/Combo.zip

 

[Bob Vance]

Thanks Arvin, Just having trouble with my query Critera
[Forms]![frmModify]![cbHorseName]
The HorseID is in The first Column of the combobox cbHorseName
Regards Bob

 

[Bob Vance]

Thanks Arvin, GREAT got it had the wrong form name Regards Bob

Thanks Arvin, Just having trouble with my query Critera
[Forms]![frmModify]![cbHorseName]
The HorseID is in The first Column of the combobox cbHorseName
Regards Bob

I have a sample file that shows how to filter 1 list box from another,
then filter the form based upon the second. It does a little more than
what you want, but should serve as a good example:

http://www.accessmvp.com/Arvin/Combo.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com