Make table query not working

[Guest]

I have a form that used to have a value list combo box that controlled a make
table query to create a report. I got smart and changed the value list combo
box to a table based combo box. Unfortunately, my make table query no longer
works. All it makes is a table with a blank record. What I have is a table
with people's names and various stuff about them. One of the fields is a
combo box that is table based. I then have another form with a combo box for
selecting one of the entries in the combo box in the main table, and then a
button to run the make table query so that a report can be generated. It
isn't working, though. Here is the query:

SELECT Contacts.Religion, Contacts.Rank, Contacts.LastName,
Contacts.FirstName, Contacts.[Battery/Section], Contacts.CheckIn INTO
ReligionSelecttbl
FROM Contacts
WHERE (((Contacts.Religion)=[Forms]![ReligionSelect]![cboReligion]))
ORDER BY Contacts.LastName;

 

[Guest]

My first thought would be that one of the fields in one of the tables is
numeric, but the other is text.

What does the table look like that is the RowSource for your cboReligion
combo box? If it has and ID field, and a text field, then, which column is
the bound column? What does the SQL look like for the combo boxes row source?

Dale

 

[Guest]

I found my problem. Believe it or not I didn't have the combo box named
correctly.

My first thought would be that one of the fields in one of the tables is
numeric, but the other is text.

What does the table look like that is the RowSource for your cboReligion
combo box? If it has and ID field, and a text field, then, which column is
the bound column? What does the SQL look like for the combo boxes row source?

Dale
--
Email address is not valid.
Please reply to newsgroup only.

I have a form that used to have a value list combo box that controlled a make
table query to create a report. I got smart and changed the value list combo
box to a table based combo box. Unfortunately, my make table query no longer
works. All it makes is a table with a blank record. What I have is a table
with people's names and various stuff about them. One of the fields is a
combo box that is table based. I then have another form with a combo box for
selecting one of the entries in the combo box in the main table, and then a
button to run the make table query so that a report can be generated. It
isn't working, though. Here is the query:

SELECT Contacts.Religion, Contacts.Rank, Contacts.LastName,
Contacts.FirstName, Contacts.[Battery/Section], Contacts.CheckIn INTO
ReligionSelecttbl
FROM Contacts
WHERE (((Contacts.Religion)=[Forms]![ReligionSelect]![cboReligion]))
ORDER BY Contacts.LastName;