12-19-06, 06:28 #1Registered User
- Join Date
- Mar 2003
Unanswered: populate a query filter via a form
I am trying to generate a query based on selections froma form:
I have a querythat i want to filter results based on selections from my form.
I am not sure whether to use checkboxes or a list box, either way i am not sure how to do what i want.
I want the user to select a line or series of lines then click a button and bing the query will be run based on the selections.
I have attached a sample of what i am tring to achieve, i need to be able to select a single line or all lines.
i am not sure how to poopulate the query with my selections
currently the form i have i have put on the 2 methods that i am looking at but at the moment i cant select more than one option. and even then i cant return the value to the query (i am not sure which selection method is the best either)
12-19-06, 14:57 #2Moderator
- Join Date
- Dec 2004
- Madison, WI
A little help
Try this attachment. I made some "really" quick mods. Hope that helps.Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)