If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using Forms for Parameter Queries
I am trying to create a parameter query that connects to
a form that uses checkboxes as the method for selecting records of individuals based on the sports that each person plays. For instance, the form would consist of three fields: Golf, football, and basketball (all checkboxes). The companion Parameter Query is based on a table, "PersonSports," with these three fields plus the person's ID number as the primary key. So the table consists of 4 fields all together: PersonID, Golf, Football, and Basketball. In the criterion section for Golf, there is the expression [Forms]![PersonSearchForm]! [Golf], indicating that the query should look to the "Golf" field of the "PersonSearch" form for the value to be used as the filter for pulling records. For the other two fields I have the same expression except the last part is altered to the appropriate field. On the "PersonSearchForm" form, I check the golf checkbox and leave the other checkboxes blank so as to pull up all records for individuals who play golf. However, the query returns only one record, and there is more than one record with the value golf in the golf field. I know that I have made a mistake in setting up the query and form. Does anyone know how to use checkboxes on forms that connect to parameter queries? Ideally, I would like to search for records using multiple fields, i.e. by checking off football and golf and retrieving all records that include these values, or by having an option where selecting football and golf pulls up only those records where a person plays both of these sports. Sorry for the long message!!! -Jon |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using Select Queries in Forms | Ben | Using Forms | 1 | August 1st, 2004 02:56 PM |
Using Forms to Providre Critieria for Queries | Mark Mesarch | Running & Setting Up Queries | 2 | June 16th, 2004 07:24 PM |
Imported Queries & Field Names - Attn S.Clark MVP | Bruce | Running & Setting Up Queries | 3 | June 14th, 2004 12:14 PM |
Find Unused Forms, Queries, Reports, etc | Ripper | General Discussion | 1 | June 7th, 2004 07:02 AM |
Exporting Multiple Queries to 1 Excel Workbook with VBA | Anthony | Running & Setting Up Queries | 2 | June 3rd, 2004 07:59 PM |