ApplyFilterMacro

  • Thread starter Thread starter jwebster1979
  • Start date Start date
J

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
 
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.
 
would I put that in the condition or arguement of the macro


Daryl S said:
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


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


jwebster1979 said:
would I put that in the condition or arguement of the macro


Daryl S said:
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


jwebster1979 said:
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
Click to expand...
Click to expand...
Click to expand...
 
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.
 
Back
Top