advanced filter option ms access 2007
Posted on 2009-02-23
I have a database in MS Access 2007. Using the advanced filter option I created a query which asks the user to key in "Approval Status" (which is a field in my table).
The sql query I used is: Like "*" & [Pls enter Approval status] & "*"
The approval status is a list box basically in my form which when you drop down shows: Approved/Expired/Terminated.
Now when i open the query as a button in my form, I have to key in a parameter value for the approval status. i.e I have to type appr or expir or whatever (is close to Approved/Expired/Terminated).
I dont wish to type in but select from a drop down box Approved/Expired/Terminated.
How to go about doing this?