ApplyFilter

G

Gina Liddle

In my form I want to pick a value from a ComboBox and use the value to
filter the "PL" field. It all sound easy but obviously not for me! I've
tried using the below code but to no avail, help would be appreciated.

PLName = cboPLFilter.Value
DoCmd.GoToControl "PL"
DoCmd.ApplyFilter , "PL = PLName"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ApplyFilter 1
VBA works in orignal but fails in copy of database 1
EXCEL ENQUIRY 1
EXCEL FORMULA ASSISTANCE 1
How to set range to autofiltered visible cells? 7
Creating a report on a current filter of a list box on a form 0
How to extract text from number/text cell 6
this recordset is not updateable 1

Top