Filter Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob V - 26 Jul 2007 09:19 GMT

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

Reply to this Message

John W. Vinson - 26 Jul 2007 18:26 GMT

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

Reply to this Message

Bob V - 29 Jul 2007 00:41 GMT

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]
[quoted text clipped - 14 lines]
>
> John W. Vinson [MVP]

Reply to this Message

John W. Vinson - 29 Jul 2007 23:24 GMT

>Thanks John, A subForm sounds good, At the Moment I have a query that is
>fielding,
[quoted text clipped - 5 lines]
>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]

Reply to this Message