Filter Question

[Bob V]

If I have a query that has 4 fields, 1 being [Charges] how do I filter a
the drop down list to show all records with the same [Charges]
So as when I click on a record in [Charges] it shows all records with that
have that!
Thanks for any Help...Bob

 

[John W. Vinson]

If I have a query that has 4 fields, 1 being [Charges] how do I filter a
the drop down list to show all records with the same [Charges]
So as when I click on a record in [Charges] it shows all records with that
have that!
Thanks for any Help...Bob

Please translate:

"all records with that have that"

is meaningless to me.

Rather than a combo box ("drop down list") you might want to consider using a
Form with a Subform... but it's not at all clear to me what you want to see.

John W. Vinson [MVP]

 

[Bob V]

Thanks John, A subForm sounds good, At the Moment I have a query that is
fielding,
qryChargeReference/ AdditionalCharge(Description),
DayNo(Date),AdditionalAmountCharge($Price), HorseID(HorseNumberID),
HorseName,Gives HorsesRaceName(Expr2). What I wanted to do is be able to
select any [AdditionalCharge] (No Duplicates) and the subform to show
records DayNo,AdditionalCharge,AdditionalChargeAmount,Expr2 that contain the
AdditionalCharge selected
Thank you for your help with this , Regards Bob

If I have a query that has 4 fields, 1 being [Charges] how do I filter a
the drop down list to show all records with the same [Charges]
So as when I click on a record in [Charges] it shows all records with that
have that!
Thanks for any Help...Bob

Please translate:

"all records with that have that"

is meaningless to me.

Rather than a combo box ("drop down list") you might want to consider
using a
Form with a Subform... but it's not at all clear to me what you want to
see.

John W. Vinson [MVP]

 

[John W. Vinson]

Thanks John, A subForm sounds good, At the Moment I have a query that is
fielding,
qryChargeReference/ AdditionalCharge(Description),
DayNo(Date),AdditionalAmountCharge($Price), HorseID(HorseNumberID),
HorseName,Gives HorsesRaceName(Expr2). What I wanted to do is be able to
select any [AdditionalCharge] (No Duplicates) and the subform to show
records DayNo,AdditionalCharge,AdditionalChargeAmount,Expr2 that contain the
AdditionalCharge selected
Thank you for your help with this , Regards Bob

If I understand you aright, you should be able to make the Master Link Field
property of the subform the name of the combo box in which you select the
additional charge, and the Child Link Field the AddtionalCharge field.

John W. Vinson [MVP]