There have been several posts that are similar to what I need, kg20079's was really close but I need to open a query instead of a form. To start with I have a table which have 15 fields, 12 of those fields hold currency which represent each month of the year and are labeled by month. I have an unbound form with a list box. The list box comes from a query that pulls only the 12 fields (months) from the table. I need the user to select the month and click a button that opens a query that shows the records for the month selected, the other 3 fields, plus a few fields from another table. Do I need to use a where statement to select the field and if so does it go in the form or in the SQL? I've written other queries that pull criteria from a form but those were only pulling one record from one field and I'm not sure how to go about using variable fields like this. Does this make sense?
Open a query using a variable field selection
- Thread starter lsc
- Start date
Similar threads
