ApplyFilterMacro

[jwebster1979]

I am trying to make an ApplyFilter Macro combo box for a subform, in the main
form. The subform name is [Transaction subform]. My goal is to filter my
products in the subform based off of the supplier I pick in the combo box in
the main form.
I am having a lot of trouble with this.
the row source for my product lookup field looks like this:
SELECT[Products].[ProductID],[Products].[ProductIdentifiersupplier],[Products].[Supplier]
FROM Products ORDER BY [ProductName],[ProductIdentifierSupplier],[Supplier];

I am not sure hos to manipulate this to make my macro work. Please help! i
am not that great at Access so please be specific!!!
Thanks

 

[Daryl S]

Jwebster1979 -

Set the filter to this (substitute your combo box name):
"[Supplier] = '" & Parent.comboboxname.Column(0) & "'"

Make sure the Allow Filters property is set to True.

 

[jwebster1979]

would I put that in the condition or arguement of the macro

Jwebster1979 -

Set the filter to this (substitute your combo box name):
"[Supplier] = '" & Parent.comboboxname.Column(0) & "'"

Make sure the Allow Filters property is set to True.

--
Daryl S

I am trying to make an ApplyFilter Macro combo box for a subform, in the main
form. The subform name is [Transaction subform]. My goal is to filter my
products in the subform based off of the supplier I pick in the combo box in
the main form.
I am having a lot of trouble with this.
the row source for my product lookup field looks like this:
SELECT[Products].[ProductID],[Products].[ProductIdentifiersupplier],[Products].[Supplier]
FROM Products ORDER BY [ProductName],[ProductIdentifierSupplier],[Supplier];

I am not sure hos to manipulate this to make my macro work. Please help! i
am not that great at Access so please be specific!!!
Thanks

 

[Daryl S]

Jwebster1979 -

This would be in the Where Condition of the macro. If you use the
expression builder (...) then that will help prevent typos...

--
Daryl S

would I put that in the condition or arguement of the macro

Jwebster1979 -

Set the filter to this (substitute your combo box name):
"[Supplier] = '" & Parent.comboboxname.Column(0) & "'"

Make sure the Allow Filters property is set to True.

--
Daryl S

I am trying to make an ApplyFilter Macro combo box for a subform, in the main
form. The subform name is [Transaction subform]. My goal is to filter my
products in the subform based off of the supplier I pick in the combo box in
the main form.
I am having a lot of trouble with this.
the row source for my product lookup field looks like this:
SELECT[Products].[ProductID],[Products].[ProductIdentifiersupplier],[Products].[Supplier]
FROM Products ORDER BY [ProductName],[ProductIdentifierSupplier],[Supplier];

I am not sure hos to manipulate this to make my macro work. Please help! i
am not that great at Access so please be specific!!!
Thanks

 

[Eighte]

Sayahng, don`t be stress with me. I just got my memory.yesterday. Ok.Kampung
boy, still untech much but getting there.
Ok. will want to be with you to do shopping. Is Baa on strict budgets?
I am telling.

The tepung attar:downstairs taste like kacang hijau. I wanted to make
savouries to warm perut. You are still hungry too.. we try sleep.no.hmm nasi
goreng sounds good. so we go and take the paste.

Caster sugar
Honey
Butter Buttercup.
Banana

Banana vanilla choc cream. very sedap.
About RM3.20/= Ok.:]. Our wedding:].
How, we can! I just am scared too of you not being with me. Did you killed a
chicken?sedap and last.hmm.