combo box frustration

[myxmaster]

Sorry floks, I have had a lot of answers to this question however I
either have some erroneous data somewhere in my tables etc, or I
simply cannot fathom it out. I y want the user to make a selection and
then filter the subform based on the selection. If anyone would be so
kind to give a simplified example based on any data I would appreciate
it. This has had me stumped for weeks and I cannot move on without
first completing this portion.
I have a combobox that selects a customer and this works fine, however
each customer has a unique wheras each customer can have many
transactions and that is why I need to filter.

Transactiontbl
Field = Category
Rowsource = "Credit";"Cash";"Check";"Other";

Subform recordsource = Transaction Query

TIA

 

[Guest]

Ok,

Let's try another one, have you tried the following:

on the after_update of the combo (in VBA)

me.parentform.subform.filter=me.combo
me.parentform.subform.filteron=true

it's worth a shot...

Maurice

 

[George Nicholson]

http://www.mvps.org/access/forms/frm0023.htm
Forms: Cannot ApplyFilter on Subform

provides one example. Note that if your subform already has Master/Child
fields established (i.e., Customer), you can exclude them from the code
indicated. Just focus on the filter for your TransactionCategory.

HTH,