COMBO BOXES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to know how to use the information in a table in a search query. For
example I have a field called "location" and if I were to search for specific
records in that field I can use a drop dwon box to select the correct
"location" instead of guessing what the specific location is. The "location"
field has a table with specific locations the user can chose on the initial
input form.

Thanks,

Ray
 
I need to know how to use the information in a table in a search query. For
example I have a field called "location" and if I were to search for specific
records in that field I can use a drop dwon box to select the correct
"location" instead of guessing what the specific location is. The "location"
field has a table with specific locations the user can chose on the initial
input form.
Click to expand...

You can easily do this by creating an unbound Form (let's call it
frmCrit) with a Combo Box named cboLocation on it, based on the
Location table. Create a Query with

=Forms![frmCrit]![cboLocation]

as a criterion on the Location field.

It's convenient to base a Form (for onscreen viewing) or a Report (for
printing) on this query, and put a button on frmCrit to open the
report or the form. There's generally no need to open the query
datasheet or to "run" the query - just open the form.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Well I have the form created as form1 with a single combo box on it. Do I
associate the box with the "location" table? and when you say creat a query
am I using the "location" field? lastly where do I put the "criterion" at?
Soory it's late and I am tired.

Thanks
Ray

John Vinson said:
I need to know how to use the information in a table in a search query. For
example I have a field called "location" and if I were to search for specific
records in that field I can use a drop dwon box to select the correct
"location" instead of guessing what the specific location is. The "location"
field has a table with specific locations the user can chose on the initial
input form.
Click to expand...

You can easily do this by creating an unbound Form (let's call it
frmCrit) with a Combo Box named cboLocation on it, based on the
Location table. Create a Query with

=Forms![frmCrit]![cboLocation]

as a criterion on the Location field.

It's convenient to base a Form (for onscreen viewing) or a Report (for
printing) on this query, and put a button on frmCrit to open the
report or the form. There's generally no need to open the query
datasheet or to "run" the query - just open the form.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
Well I have the form created as form1 with a single combo box on it. Do I
associate the box with the "location" table? and when you say creat a query
am I using the "location" field? lastly where do I put the "criterion" at?
Soory it's late and I am tired.
Click to expand...

No... I should have made it clear, since it's a common and dangerous
error! A Combo Box used for this purpose MUST be unbound - frmCrit
should have *no* Recordsource, and the combo box should have *no*
Control Source.

To create the Query, open the Query tab and create a new Query based
on your table. I presume you want to use this combo box to search a
field called "Location" (remember, I can't see your database). If so,
put the suggested criterion on the Criteria line underneath that
field. If it's some other field that you want to search, put the
criterion on the criteria line under THAT field.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
John,

Here is the sql for the query:

SELECT SITE.LOCATION
FROM SITE
WHERE (((SITE.LOCATION)=[Forms]![Form1]![LOCATION]));

It keeps making it a query box when I use it.

I have got my form "Form1" created that is unbound and a combox that is also
unbound. My Table is called "SITE" with location as a field.

What am I doing wrong?

Ray
 
John,

Here is the sql for the query:

SELECT SITE.LOCATION
FROM SITE
WHERE (((SITE.LOCATION)=[Forms]![Form1]![LOCATION]));

It keeps making it a query box when I use it.

I have got my form "Form1" created that is unbound and a combox that is also
unbound. My Table is called "SITE" with location as a field.

What am I doing wrong?
Click to expand...

Probably running the query without Form1 being open. Open the form
first, select the location, and THEN run the query It's probably best
to run the query, or a Form or Report based on the query, by putting a
command button on Form1.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Ok... have "Form1" open. Then run the query "query1" still only shows the
query box asking for some type of iput. Also how do I get the combo box to
pull up the information if it is unbound to anything? or do I use the Row
Type and Row Source to pull the information? Also do I need to use "cbo"? and
do I name the combo box "LOCATION"?

Ray

John Vinson said:
John,

Here is the sql for the query:

SELECT SITE.LOCATION
FROM SITE
WHERE (((SITE.LOCATION)=[Forms]![Form1]![LOCATION]));

It keeps making it a query box when I use it.

I have got my form "Form1" created that is unbound and a combox that is also
unbound. My Table is called "SITE" with location as a field.

What am I doing wrong?
Click to expand...

Probably running the query without Form1 being open. Open the form
first, select the location, and THEN run the query It's probably best
to run the query, or a Form or Report based on the query, by putting a
command button on Form1.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
Ok... have "Form1" open. Then run the query "query1" still only shows the
query box asking for some type of iput. Also how do I get the combo box to
pull up the information if it is unbound to anything? or do I use the Row
Type and Row Source to pull the information? Also do I need to use "cbo"? and
do I name the combo box "LOCATION"?
Click to expand...

Sorry... making assumptions on my part! Let's take this step by step.

1. Create a Form named frmCrit. The form should be unbound.
2. Create a Combo Box on frmCrit named cboLocation. Its RowSource
(where it gets its data) should be the Location table, or a query on
the location table, sorting the locations alphabetically let's say.
Its Control Source should be blank - you want to use this combo box to
create a criterion, NOT to store or display data.
3. Create a Query on the table that you want to display. As a
criterion on the field containing the location put

=[Forms]![frmCrit]![cboLocation]

This will cause the query to look for the value selected in that combo
box; if the form is not open, or there is no form named frmCrit, or it
has no control named cboLocation, you'll get prompted to enter
[Forms]![frmCrit]![cboLocation].

4. Create a Form based on this query, displaying the results in a
suitable layout.
5. Put a command button on frmCrit, using the command button wizard,
to open this data display form and close frmCrit.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
OK got it to work on a single form but when I apply it to my Main form I do
not get it to pull up any data that is already been input. I need it to pull
of ALL records with that specific "LOCATION" that the user selected.

Ray

I do appreciate all your assistance as I am still learning Access.

John Vinson said:
Ok... have "Form1" open. Then run the query "query1" still only shows the
query box asking for some type of iput. Also how do I get the combo box to
pull up the information if it is unbound to anything? or do I use the Row
Type and Row Source to pull the information? Also do I need to use "cbo"? and
do I name the combo box "LOCATION"?
Click to expand...

Sorry... making assumptions on my part! Let's take this step by step.

1. Create a Form named frmCrit. The form should be unbound.
2. Create a Combo Box on frmCrit named cboLocation. Its RowSource
(where it gets its data) should be the Location table, or a query on
the location table, sorting the locations alphabetically let's say.
Its Control Source should be blank - you want to use this combo box to
create a criterion, NOT to store or display data.
3. Create a Query on the table that you want to display. As a
criterion on the field containing the location put

=[Forms]![frmCrit]![cboLocation]

This will cause the query to look for the value selected in that combo
box; if the form is not open, or there is no form named frmCrit, or it
has no control named cboLocation, you'll get prompted to enter
[Forms]![frmCrit]![cboLocation].

4. Create a Form based on this query, displaying the results in a
suitable layout.
5. Put a command button on frmCrit, using the command button wizard,
to open this data display form and close frmCrit.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
OK got it to work on a single form but when I apply it to my Main form I do
not get it to pull up any data that is already been input. I need it to pull
of ALL records with that specific "LOCATION" that the user selected.
Click to expand...

What is the Recordsource of your main form?
What is the SQL of the query using the criterion?
What actual code do you use?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Recordsource of main form? ENTRY Query using ENTRY table data
What is the SQL of the query using the criterion?
SELECT ENTRY.ENTRYID, ENTRY.IMPORT, ENTRY.DATETKN, ENTRY.TIMETKN,
ENTRY.TYPE, ENTRY.LOCATION, ENTRY.BOOTH, ENTRY.SITE, ENTRY.CONDITION,
ENTRY.PHOTO, ENTRY.PERMISSION, ENTRY.POLICE, ENTRY.POLOFF, ENTRY.POLRPT,
ENTRY.POLCASE, ENTRY.NAME1, ENTRY.DOB1, ENTRY.BUSNAM1, ENTRY.ADD1,
ENTRY.APT1, ENTRY.CITY1, ENTRY.STATE1, ENTRY.ZIP1, ENTRY.DLNUM1, ENTRY.DLST1,
ENTRY.DAYPHN1, ENTRY.OTHPHN1, ENTRY.NAME2, ENTRY.DOB2, ENTRY.BUSNAM2,
ENTRY.ADD2, ENTRY.APT2, ENTRY.CITY2, ENTRY.STATE2, ENTRY.ZIP2, ENTRY.DLNUM2,
ENTRY.DLST2, ENTRY.DAYPHN2, ENTRY.OTHPHN2, ENTRY.INCIDESCP, ENTRY.INJRDESCP,
ENTRY.MEDASST, ENTRY.MEDASSTBY, ENTRY.XPORT, ENTRY.XPPORTWHR, ENTRY.VEHOWN1,
ENTRY.VEHOPR1, ENTRY.VEHVIN1, ENTRY.VEHPLT1, ENTRY.VEHINS1, ENTRY.VEHPOL1,
ENTRY.VEHOWN2, ENTRY.VEHOPR2, ENTRY.VEHVIN2, ENTRY.VEHPLT2, ENTRY.VEHINS2,
ENTRY.VEHPOL2, ENTRY.THEFT1, ENTRY.VALUE1, ENTRY.THEFT2, ENTRY.VALUE2,
ENTRY.THEFT3, ENTRY.VALUE3, ENTRY.THEFT4, ENTRY.VALUE4, ENTRY.THEFT5,
ENTRY.VALUE5, ENTRY.THEFT6, ENTRY.VALUE6, ENTRY.THEFT7, ENTRY.VALUE7,
ENTRY.THEFT8, ENTRY.VALUE8, ENTRY.WITNAM1, ENTRY.RELAT1, ENTRY.ADD3,
ENTRY.APT3, ENTRY.CITY3, ENTRY.STATE3, ENTRY.ZIP3, ENTRY.DAYPHN3,
ENTRY.OTHPHN3, ENTRY.WITNAM2, ENTRY.RELAT2, ENTRY.ADD4, ENTRY.APT4,
ENTRY.CITY4, ENTRY.STATE4, ENTRY.ZIP4, ENTRY.DAYPHN4, ENTRY.OTHPHN4,
ENTRY.ADDITIONAL, ENTRY.RPTWRTR, ENTRY.RPTDATE, ENTRY.[INPUT BY]
FROM ENTRY
WHERE (((ENTRY.SITE) Like "*" & [ENTER SITE] & "*"))
ORDER BY ENTRY.SITE;
What actual code do you use? Code?
Click to expand...
 
FROM ENTRY
WHERE (((ENTRY.SITE) Like "*" & [ENTER SITE] & "*"))
ORDER BY ENTRY.SITE;
Click to expand...

Umm...

Ok. So you did not use the form reference as a criterion, as I've been
suggesting all along. You're using a prompt [ENTER SITE] as the
criterion.

May I request that you reread this thread, and consider actually doing
what was suggested?

To reiterate:

1. Create a Form named frmCrit. The form should be unbound.
2. Create a Combo Box on frmCrit named cboLocation. Its RowSource
(where it gets its data) should be the Location table, or a query on
the location table, sorting the locations alphabetically let's say.
Its Control Source should be blank - you want to use this combo box to
create a criterion, NOT to store or display data.
3. Create a Query on the table that you want to display. As a
criterion on the field containing the location put

=[Forms]![frmCrit]![cboLocation]

If you replace [ENTER SITE] above with this forms reference, and if
you have a form named frmCrit with a combo box named cboLocation, the
query will return the values where ENTRY.SITE is equal to the selected
location.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
John,

Sorry I actually did use it but I sent the older version of the query sql to
you. I am at work currently and I will send you the one with the information
you provided tonight when I get home.

Again, I do appreciate all of you r help!

Ray


John Vinson said:
FROM ENTRY
WHERE (((ENTRY.SITE) Like "*" & [ENTER SITE] & "*"))
ORDER BY ENTRY.SITE;
Click to expand...

Umm...

Ok. So you did not use the form reference as a criterion, as I've been
suggesting all along. You're using a prompt [ENTER SITE] as the
criterion.

May I request that you reread this thread, and consider actually doing
what was suggested?

To reiterate:

1. Create a Form named frmCrit. The form should be unbound.
2. Create a Combo Box on frmCrit named cboLocation. Its RowSource
(where it gets its data) should be the Location table, or a query on
the location table, sorting the locations alphabetically let's say.
Its Control Source should be blank - you want to use this combo box to
create a criterion, NOT to store or display data.
3. Create a Query on the table that you want to display. As a
criterion on the field containing the location put

=[Forms]![frmCrit]![cboLocation]

If you replace [ENTER SITE] above with this forms reference, and if
you have a form named frmCrit with a combo box named cboLocation, the
query will return the values where ENTRY.SITE is equal to the selected
location.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
John here is the query with the criteria you suggested:
SELECT ENTRY.ENTRYID, ENTRY.IMPORT, ENTRY.DATETKN, ENTRY.TIMETKN,
ENTRY.TYPE, ENTRY.LOCATION, ENTRY.BOOTH, ENTRY.SITE, ENTRY.CONDITION,
ENTRY.PHOTO, ENTRY.PERMISSION, ENTRY.POLICE, ENTRY.POLOFF, ENTRY.POLRPT,
ENTRY.POLCASE, ENTRY.NAME1, ENTRY.DOB1, ENTRY.BUSNAM1, ENTRY.ADD1,
ENTRY.APT1, ENTRY.CITY1, ENTRY.STATE1, ENTRY.ZIP1, ENTRY.DLNUM1, ENTRY.DLST1,
ENTRY.DAYPHN1, ENTRY.OTHPHN1, ENTRY.NAME2, ENTRY.DOB2, ENTRY.BUSNAM2,
ENTRY.ADD2, ENTRY.APT2, ENTRY.CITY2, ENTRY.STATE2, ENTRY.ZIP2, ENTRY.DLNUM2,
ENTRY.DLST2, ENTRY.DAYPHN2, ENTRY.OTHPHN2, ENTRY.INCIDESCP, ENTRY.INJRDESCP,
ENTRY.MEDASST, ENTRY.MEDASSTBY, ENTRY.XPORT, ENTRY.XPPORTWHR, ENTRY.VEHOWN1,
ENTRY.VEHOPR1, ENTRY.VEHVIN1, ENTRY.VEHPLT1, ENTRY.VEHINS1, ENTRY.VEHPOL1,
ENTRY.VEHOWN2, ENTRY.VEHOPR2, ENTRY.VEHVIN2, ENTRY.VEHPLT2, ENTRY.VEHINS2,
ENTRY.VEHPOL2, ENTRY.THEFT1, ENTRY.VALUE1, ENTRY.THEFT2, ENTRY.VALUE2,
ENTRY.THEFT3, ENTRY.VALUE3, ENTRY.THEFT4, ENTRY.VALUE4, ENTRY.THEFT5,
ENTRY.VALUE5, ENTRY.THEFT6, ENTRY.VALUE6, ENTRY.THEFT7, ENTRY.VALUE7,
ENTRY.THEFT8, ENTRY.VALUE8, ENTRY.WITNAM1, ENTRY.RELAT1, ENTRY.ADD3,
ENTRY.APT3, ENTRY.CITY3, ENTRY.STATE3, ENTRY.ZIP3, ENTRY.DAYPHN3,
ENTRY.OTHPHN3, ENTRY.WITNAM2, ENTRY.RELAT2, ENTRY.ADD4, ENTRY.APT4,
ENTRY.CITY4, ENTRY.STATE4, ENTRY.ZIP4, ENTRY.DAYPHN4, ENTRY.OTHPHN4,
ENTRY.ADDITIONAL, ENTRY.RPTWRTR, ENTRY.RPTDATE, ENTRY.[INPUT BY], ENTRY.CAMERA
FROM ENTRY
WHERE (((ENTRY.LOCATION)=[Forms]![SITE SEARCH]![LOCATION]));
 
John here is the query with the criteria you suggested:
SELECT ENTRY.ENTRYID, ENTRY.IMPORT, ENTRY.DATETKN, ENTRY.TIMETKN,
ENTRY.TYPE, ENTRY.LOCATION, ENTRY.BOOTH, ENTRY.SITE, ENTRY.CONDITION,
ENTRY.PHOTO, ENTRY.PERMISSION, ENTRY.POLICE, ENTRY.POLOFF, ENTRY.POLRPT,
ENTRY.POLCASE, ENTRY.NAME1, ENTRY.DOB1, ENTRY.BUSNAM1, ENTRY.ADD1,
ENTRY.APT1, ENTRY.CITY1, ENTRY.STATE1, ENTRY.ZIP1, ENTRY.DLNUM1, ENTRY.DLST1,
ENTRY.DAYPHN1, ENTRY.OTHPHN1, ENTRY.NAME2, ENTRY.DOB2, ENTRY.BUSNAM2,
ENTRY.ADD2, ENTRY.APT2, ENTRY.CITY2, ENTRY.STATE2, ENTRY.ZIP2, ENTRY.DLNUM2,
ENTRY.DLST2, ENTRY.DAYPHN2, ENTRY.OTHPHN2, ENTRY.INCIDESCP, ENTRY.INJRDESCP,
ENTRY.MEDASST, ENTRY.MEDASSTBY, ENTRY.XPORT, ENTRY.XPPORTWHR, ENTRY.VEHOWN1,
ENTRY.VEHOPR1, ENTRY.VEHVIN1, ENTRY.VEHPLT1, ENTRY.VEHINS1, ENTRY.VEHPOL1,
ENTRY.VEHOWN2, ENTRY.VEHOPR2, ENTRY.VEHVIN2, ENTRY.VEHPLT2, ENTRY.VEHINS2,
ENTRY.VEHPOL2, ENTRY.THEFT1, ENTRY.VALUE1, ENTRY.THEFT2, ENTRY.VALUE2,
ENTRY.THEFT3, ENTRY.VALUE3, ENTRY.THEFT4, ENTRY.VALUE4, ENTRY.THEFT5,
ENTRY.VALUE5, ENTRY.THEFT6, ENTRY.VALUE6, ENTRY.THEFT7, ENTRY.VALUE7,
ENTRY.THEFT8, ENTRY.VALUE8, ENTRY.WITNAM1, ENTRY.RELAT1, ENTRY.ADD3,
ENTRY.APT3, ENTRY.CITY3, ENTRY.STATE3, ENTRY.ZIP3, ENTRY.DAYPHN3,
ENTRY.OTHPHN3, ENTRY.WITNAM2, ENTRY.RELAT2, ENTRY.ADD4, ENTRY.APT4,
ENTRY.CITY4, ENTRY.STATE4, ENTRY.ZIP4, ENTRY.DAYPHN4, ENTRY.OTHPHN4,
ENTRY.ADDITIONAL, ENTRY.RPTWRTR, ENTRY.RPTDATE, ENTRY.[INPUT BY], ENTRY.CAMERA
FROM ENTRY
WHERE (((ENTRY.LOCATION)=[Forms]![SITE SEARCH]![LOCATION]));
Click to expand...

Now I'm REALLY confused.

This query will return only those records in the (badly
non-normalized, in need of restructuring) table ENTRY for which the
LOCATION field is equal to the value selected in the combo box named
LOCATION on the form SITE SEARCH.

Is this not what you are seeing? What are you doing with the query?
Opening it, using it as the Recordsource for some other form, or what?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
John,

Obviously I am new at Acess. I am trying to learn but not many folks I
personally know are even vaugley familiar with Access let alone know any of
the intricacies. I have learned most of what little I know with a lot of
trial and error, but here is what I need.

I have a "incident Report" I am puting together for an organization. As you
can see by the SQL it requires a lot of different fields. I need a good way
of searching for a specifc record(s) containing, for example, location or a
date or a date range or a name, etc. You said this was "badly
non-normalized, in need of restructuring". That I have no doubt, so I would
appreciate ANY inforamtion to be able to present this project in a clear
"normalized" format. Any suggestions to include a good Access study guide is
welcomed. Also, is there a way of communicating in another venue other than
here? I can send you my personal email.

Ray

Ray


John here is the query with the criteria you suggested:
SELECT ENTRY.ENTRYID, ENTRY.IMPORT, ENTRY.DATETKN, ENTRY.TIMETKN,
ENTRY.TYPE, ENTRY.LOCATION, ENTRY.BOOTH, ENTRY.SITE, ENTRY.CONDITION,
ENTRY.PHOTO, ENTRY.PERMISSION, ENTRY.POLICE, ENTRY.POLOFF, ENTRY.POLRPT,
ENTRY.POLCASE, ENTRY.NAME1, ENTRY.DOB1, ENTRY.BUSNAM1, ENTRY.ADD1,
ENTRY.APT1, ENTRY.CITY1, ENTRY.STATE1, ENTRY.ZIP1, ENTRY.DLNUM1, ENTRY.DLST1,
ENTRY.DAYPHN1, ENTRY.OTHPHN1, ENTRY.NAME2, ENTRY.DOB2, ENTRY.BUSNAM2,
ENTRY.ADD2, ENTRY.APT2, ENTRY.CITY2, ENTRY.STATE2, ENTRY.ZIP2, ENTRY.DLNUM2,
ENTRY.DLST2, ENTRY.DAYPHN2, ENTRY.OTHPHN2, ENTRY.INCIDESCP, ENTRY.INJRDESCP,
ENTRY.MEDASST, ENTRY.MEDASSTBY, ENTRY.XPORT, ENTRY.XPPORTWHR, ENTRY.VEHOWN1,
ENTRY.VEHOPR1, ENTRY.VEHVIN1, ENTRY.VEHPLT1, ENTRY.VEHINS1, ENTRY.VEHPOL1,
ENTRY.VEHOWN2, ENTRY.VEHOPR2, ENTRY.VEHVIN2, ENTRY.VEHPLT2, ENTRY.VEHINS2,
ENTRY.VEHPOL2, ENTRY.THEFT1, ENTRY.VALUE1, ENTRY.THEFT2, ENTRY.VALUE2,
ENTRY.THEFT3, ENTRY.VALUE3, ENTRY.THEFT4, ENTRY.VALUE4, ENTRY.THEFT5,
ENTRY.VALUE5, ENTRY.THEFT6, ENTRY.VALUE6, ENTRY.THEFT7, ENTRY.VALUE7,
ENTRY.THEFT8, ENTRY.VALUE8, ENTRY.WITNAM1, ENTRY.RELAT1, ENTRY.ADD3,
ENTRY.APT3, ENTRY.CITY3, ENTRY.STATE3, ENTRY.ZIP3, ENTRY.DAYPHN3,
ENTRY.OTHPHN3, ENTRY.WITNAM2, ENTRY.RELAT2, ENTRY.ADD4, ENTRY.APT4,
ENTRY.CITY4, ENTRY.STATE4, ENTRY.ZIP4, ENTRY.DAYPHN4, ENTRY.OTHPHN4,
ENTRY.ADDITIONAL, ENTRY.RPTWRTR, ENTRY.RPTDATE, ENTRY.[INPUT BY], ENTRY.CAMERA
FROM ENTRY
WHERE (((ENTRY.LOCATION)=[Forms]![SITE SEARCH]![LOCATION]));
Click to expand...

Now I'm REALLY confused.

This query will return only those records in the (badly
non-normalized, in need of restructuring) table ENTRY for which the
LOCATION field is equal to the value selected in the combo box named
LOCATION on the form SITE SEARCH.

Is this not what you are seeing? What are you doing with the query?
Opening it, using it as the Recordsource for some other form, or what?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
Back
Top