Filter Question

B

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
 
J

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
Click to expand...

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]
 
B

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

John W. Vinson said:
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
Click to expand...

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]
Click to expand...
 
J

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
Click to expand...

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]
 
Top