Parameter Value Dialogbox

L

loudawg

I've read almost all the msg for the above, but I haven't found a solution to
mine.
Which is...
A have a form=frm_State, when I open the form I get the dialog box with
SCC_Enrollment_PDP_200706.Organization Name.

I have 2 tables=SCC_Enrollment_PDP_200706 & SCC_Enrollment_PDP_200707. I
changed the 200706 to 200707 and voila...Dialog box!!!

I can't see where it references the 200706 table. Here is the SQL for the
query:
SELECT SCC_Enrollment_PDP_200707.State, SCC_Enrollment_PDP_200707.Enrolled,
SCC_Enrollment_PDP_200707.County, SCC_Enrollment_PDP_200707.[Contract ID],
SCC_Enrollment_PDP_200707.[Organization Name]
FROM SCC_Enrollment_PDP_200707
WHERE (((SCC_Enrollment_PDP_200707.State) Like [forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.County) Like
[forms]![frm_State] & "*" & [txt_Other1] & "*")) OR
(((SCC_Enrollment_PDP_200707.[Contract ID]) Like [forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.[Organization Name])
Like [forms]![frm_State] & "*" & [txt_Other1] & "*"));

The query works correctly, I just don't want to see the dialog box. Any help
will be greatly appreciated.
 
O

Ofer Cohen

1. Make sure that the field [Organization Name] exist in the table
2. Also, are you sure the query works with this criteria
SCC_Enrollment_PDP_200707.State Like [forms]![frm_State] & "*" &
[txt_Other1] & "*"

When the field name is not connected to the string, instead try
SCC_Enrollment_PDP_200707.State Like "*" & [forms]![frm_State]![txt_Other1]
& "*"

chaging all the crieria's
 
L

loudawg

Ofer,
The field exists. That's one of the first things I looked at. I have no idea
why it keeps referencing the 200706 table when I've changed it to 200707
table. I can't find where it thinks it lost the "field"

I made the change you suggested, but I still get the dialog box.

Thanks for your help, but I am stumped.

Ofer Cohen said:
1. Make sure that the field [Organization Name] exist in the table
2. Also, are you sure the query works with this criteria
SCC_Enrollment_PDP_200707.State Like [forms]![frm_State] & "*" &
[txt_Other1] & "*"

When the field name is not connected to the string, instead try
SCC_Enrollment_PDP_200707.State Like "*" & [forms]![frm_State]![txt_Other1]
& "*"

chaging all the crieria's

--
Good Luck
BS"D


loudawg said:
I've read almost all the msg for the above, but I haven't found a solution to
mine.
Which is...
A have a form=frm_State, when I open the form I get the dialog box with
SCC_Enrollment_PDP_200706.Organization Name.

I have 2 tables=SCC_Enrollment_PDP_200706 & SCC_Enrollment_PDP_200707. I
changed the 200706 to 200707 and voila...Dialog box!!!

I can't see where it references the 200706 table. Here is the SQL for the
query:
SELECT SCC_Enrollment_PDP_200707.State, SCC_Enrollment_PDP_200707.Enrolled,
SCC_Enrollment_PDP_200707.County, SCC_Enrollment_PDP_200707.[Contract ID],
SCC_Enrollment_PDP_200707.[Organization Name]
FROM SCC_Enrollment_PDP_200707
WHERE (((SCC_Enrollment_PDP_200707.State) Like [forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.County) Like
[forms]![frm_State] & "*" & [txt_Other1] & "*")) OR
(((SCC_Enrollment_PDP_200707.[Contract ID]) Like [forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.[Organization Name])
Like [forms]![frm_State] & "*" & [txt_Other1] & "*"));

The query works correctly, I just don't want to see the dialog box. Any help
will be greatly appreciated.
Click to expand...
Click to expand...
 
O

Ofer Cohen

Copy the SQL to a new query and see what happen

--
Good Luck
BS"D


loudawg said:
Ofer,
The field exists. That's one of the first things I looked at. I have no idea
why it keeps referencing the 200706 table when I've changed it to 200707
table. I can't find where it thinks it lost the "field"

I made the change you suggested, but I still get the dialog box.

Thanks for your help, but I am stumped.

Ofer Cohen said:
1. Make sure that the field [Organization Name] exist in the table
2. Also, are you sure the query works with this criteria
SCC_Enrollment_PDP_200707.State Like [forms]![frm_State] & "*" &
[txt_Other1] & "*"

When the field name is not connected to the string, instead try
SCC_Enrollment_PDP_200707.State Like "*" & [forms]![frm_State]![txt_Other1]
& "*"

chaging all the crieria's

--
Good Luck
BS"D


loudawg said:
I've read almost all the msg for the above, but I haven't found a solution to
mine.
Which is...
A have a form=frm_State, when I open the form I get the dialog box with
SCC_Enrollment_PDP_200706.Organization Name.

I have 2 tables=SCC_Enrollment_PDP_200706 & SCC_Enrollment_PDP_200707. I
changed the 200706 to 200707 and voila...Dialog box!!!

I can't see where it references the 200706 table. Here is the SQL for the
query:
SELECT SCC_Enrollment_PDP_200707.State, SCC_Enrollment_PDP_200707.Enrolled,
SCC_Enrollment_PDP_200707.County, SCC_Enrollment_PDP_200707.[Contract ID],
SCC_Enrollment_PDP_200707.[Organization Name]
FROM SCC_Enrollment_PDP_200707
WHERE (((SCC_Enrollment_PDP_200707.State) Like [forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.County) Like
[forms]![frm_State] & "*" & [txt_Other1] & "*")) OR
(((SCC_Enrollment_PDP_200707.[Contract ID]) Like [forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.[Organization Name])
Like [forms]![frm_State] & "*" & [txt_Other1] & "*"));

The query works correctly, I just don't want to see the dialog box. Any help
will be greatly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
O

Ofer Cohen

In the query you might have a filter defined and this is why you get the
message.
Open the query properties and check the filter poperty

--
Good Luck
BS"D


loudawg said:
Ofer,
The field exists. That's one of the first things I looked at. I have no idea
why it keeps referencing the 200706 table when I've changed it to 200707
table. I can't find where it thinks it lost the "field"

I made the change you suggested, but I still get the dialog box.

Thanks for your help, but I am stumped.

Ofer Cohen said:
1. Make sure that the field [Organization Name] exist in the table
2. Also, are you sure the query works with this criteria
SCC_Enrollment_PDP_200707.State Like [forms]![frm_State] & "*" &
[txt_Other1] & "*"

When the field name is not connected to the string, instead try
SCC_Enrollment_PDP_200707.State Like "*" & [forms]![frm_State]![txt_Other1]
& "*"

chaging all the crieria's

--
Good Luck
BS"D


loudawg said:
I've read almost all the msg for the above, but I haven't found a solution to
mine.
Which is...
A have a form=frm_State, when I open the form I get the dialog box with
SCC_Enrollment_PDP_200706.Organization Name.

I have 2 tables=SCC_Enrollment_PDP_200706 & SCC_Enrollment_PDP_200707. I
changed the 200706 to 200707 and voila...Dialog box!!!

I can't see where it references the 200706 table. Here is the SQL for the
query:
SELECT SCC_Enrollment_PDP_200707.State, SCC_Enrollment_PDP_200707.Enrolled,
SCC_Enrollment_PDP_200707.County, SCC_Enrollment_PDP_200707.[Contract ID],
SCC_Enrollment_PDP_200707.[Organization Name]
FROM SCC_Enrollment_PDP_200707
WHERE (((SCC_Enrollment_PDP_200707.State) Like [forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.County) Like
[forms]![frm_State] & "*" & [txt_Other1] & "*")) OR
(((SCC_Enrollment_PDP_200707.[Contract ID]) Like [forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.[Organization Name])
Like [forms]![frm_State] & "*" & [txt_Other1] & "*"));

The query works correctly, I just don't want to see the dialog box. Any help
will be greatly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
L

loudawg

Tried that too...same result....I'm sure it's so simple I just can't see it.

Ofer Cohen said:
Copy the SQL to a new query and see what happen

--
Good Luck
BS"D


loudawg said:
Ofer,
The field exists. That's one of the first things I looked at. I have no idea
why it keeps referencing the 200706 table when I've changed it to 200707
table. I can't find where it thinks it lost the "field"

I made the change you suggested, but I still get the dialog box.

Thanks for your help, but I am stumped.

Ofer Cohen said:
1. Make sure that the field [Organization Name] exist in the table
2. Also, are you sure the query works with this criteria
SCC_Enrollment_PDP_200707.State Like [forms]![frm_State] & "*" &
[txt_Other1] & "*"

When the field name is not connected to the string, instead try
SCC_Enrollment_PDP_200707.State Like "*" & [forms]![frm_State]![txt_Other1]
& "*"

chaging all the crieria's

--
Good Luck
BS"D


:

I've read almost all the msg for the above, but I haven't found a solution to
mine.
Which is...
A have a form=frm_State, when I open the form I get the dialog box with
SCC_Enrollment_PDP_200706.Organization Name.

I have 2 tables=SCC_Enrollment_PDP_200706 & SCC_Enrollment_PDP_200707. I
changed the 200706 to 200707 and voila...Dialog box!!!

I can't see where it references the 200706 table. Here is the SQL for the
query:
SELECT SCC_Enrollment_PDP_200707.State, SCC_Enrollment_PDP_200707.Enrolled,
SCC_Enrollment_PDP_200707.County, SCC_Enrollment_PDP_200707.[Contract ID],
SCC_Enrollment_PDP_200707.[Organization Name]
FROM SCC_Enrollment_PDP_200707
WHERE (((SCC_Enrollment_PDP_200707.State) Like [forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.County) Like
[forms]![frm_State] & "*" & [txt_Other1] & "*")) OR
(((SCC_Enrollment_PDP_200707.[Contract ID]) Like [forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.[Organization Name])
Like [forms]![frm_State] & "*" & [txt_Other1] & "*"));

The query works correctly, I just don't want to see the dialog box. Any help
will be greatly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
L

loudawg

No filters...it worked fine before I changed the table...It used to be the
200706 table, then I changed it to the 200707 table.

If that was the problem, it should have prompted for each field. Ah!!!!
Venting.

Thanks again for your help.

Ofer Cohen said:
In the query you might have a filter defined and this is why you get the
message.
Open the query properties and check the filter poperty

--
Good Luck
BS"D


loudawg said:
Ofer,
The field exists. That's one of the first things I looked at. I have no idea
why it keeps referencing the 200706 table when I've changed it to 200707
table. I can't find where it thinks it lost the "field"

I made the change you suggested, but I still get the dialog box.

Thanks for your help, but I am stumped.

Ofer Cohen said:
1. Make sure that the field [Organization Name] exist in the table
2. Also, are you sure the query works with this criteria
SCC_Enrollment_PDP_200707.State Like [forms]![frm_State] & "*" &
[txt_Other1] & "*"

When the field name is not connected to the string, instead try
SCC_Enrollment_PDP_200707.State Like "*" & [forms]![frm_State]![txt_Other1]
& "*"

chaging all the crieria's

--
Good Luck
BS"D


:

I've read almost all the msg for the above, but I haven't found a solution to
mine.
Which is...
A have a form=frm_State, when I open the form I get the dialog box with
SCC_Enrollment_PDP_200706.Organization Name.

I have 2 tables=SCC_Enrollment_PDP_200706 & SCC_Enrollment_PDP_200707. I
changed the 200706 to 200707 and voila...Dialog box!!!

I can't see where it references the 200706 table. Here is the SQL for the
query:
SELECT SCC_Enrollment_PDP_200707.State, SCC_Enrollment_PDP_200707.Enrolled,
SCC_Enrollment_PDP_200707.County, SCC_Enrollment_PDP_200707.[Contract ID],
SCC_Enrollment_PDP_200707.[Organization Name]
FROM SCC_Enrollment_PDP_200707
WHERE (((SCC_Enrollment_PDP_200707.State) Like [forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.County) Like
[forms]![frm_State] & "*" & [txt_Other1] & "*")) OR
(((SCC_Enrollment_PDP_200707.[Contract ID]) Like [forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.[Organization Name])
Like [forms]![frm_State] & "*" & [txt_Other1] & "*"));

The query works correctly, I just don't want to see the dialog box. Any help
will be greatly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
O

Ofer Cohen

Run the RecordSource of the SQL without the form, do you get the message?

If the SQL run fine without the form, check the form mybe there is a text
box defined with a control source that refer to the old table, also check the
form filter property.


--
Good Luck
BS"D


loudawg said:
Tried that too...same result....I'm sure it's so simple I just can't see it.

Ofer Cohen said:
Copy the SQL to a new query and see what happen

--
Good Luck
BS"D


loudawg said:
Ofer,
The field exists. That's one of the first things I looked at. I have no idea
why it keeps referencing the 200706 table when I've changed it to 200707
table. I can't find where it thinks it lost the "field"

I made the change you suggested, but I still get the dialog box.

Thanks for your help, but I am stumped.

:

1. Make sure that the field [Organization Name] exist in the table
2. Also, are you sure the query works with this criteria
SCC_Enrollment_PDP_200707.State Like [forms]![frm_State] & "*" &
[txt_Other1] & "*"

When the field name is not connected to the string, instead try
SCC_Enrollment_PDP_200707.State Like "*" & [forms]![frm_State]![txt_Other1]
& "*"

chaging all the crieria's

--
Good Luck
BS"D


:

I've read almost all the msg for the above, but I haven't found a solution to
mine.
Which is...
A have a form=frm_State, when I open the form I get the dialog box with
SCC_Enrollment_PDP_200706.Organization Name.

I have 2 tables=SCC_Enrollment_PDP_200706 & SCC_Enrollment_PDP_200707. I
changed the 200706 to 200707 and voila...Dialog box!!!

I can't see where it references the 200706 table. Here is the SQL for the
query:
SELECT SCC_Enrollment_PDP_200707.State, SCC_Enrollment_PDP_200707.Enrolled,
SCC_Enrollment_PDP_200707.County, SCC_Enrollment_PDP_200707.[Contract ID],
SCC_Enrollment_PDP_200707.[Organization Name]
FROM SCC_Enrollment_PDP_200707
WHERE (((SCC_Enrollment_PDP_200707.State) Like [forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.County) Like
[forms]![frm_State] & "*" & [txt_Other1] & "*")) OR
(((SCC_Enrollment_PDP_200707.[Contract ID]) Like [forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.[Organization Name])
Like [forms]![frm_State] & "*" & [txt_Other1] & "*"));

The query works correctly, I just don't want to see the dialog box. Any help
will be greatly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
J

John Spencer

If you copied the SQL from the query (View: SQL)
-- Pasted the SQL into a NEW query
-- and run the query outside the form
-- and still have the problem with the query, then I am stumped.

On the other hand if the query runs without the prompt then I suspect that
the form references
SCC_Enrollment_PDP_200706.Organization Name
someplace. - in a filter, a form control, in an order by)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

loudawg said:
No filters...it worked fine before I changed the table...It used to be the
200706 table, then I changed it to the 200707 table.

If that was the problem, it should have prompted for each field. Ah!!!!
Venting.

Thanks again for your help.

Ofer Cohen said:
In the query you might have a filter defined and this is why you get the
message.
Open the query properties and check the filter poperty

--
Good Luck
BS"D


loudawg said:
Ofer,
The field exists. That's one of the first things I looked at. I have no
idea
why it keeps referencing the 200706 table when I've changed it to
200707
table. I can't find where it thinks it lost the "field"

I made the change you suggested, but I still get the dialog box.

Thanks for your help, but I am stumped.

:

1. Make sure that the field [Organization Name] exist in the table
2. Also, are you sure the query works with this criteria
SCC_Enrollment_PDP_200707.State Like [forms]![frm_State] & "*" &
[txt_Other1] & "*"

When the field name is not connected to the string, instead try
SCC_Enrollment_PDP_200707.State Like "*" &
[forms]![frm_State]![txt_Other1]
& "*"

chaging all the crieria's

--
Good Luck
BS"D


:

I've read almost all the msg for the above, but I haven't found a
solution to
mine.
Which is...
A have a form=frm_State, when I open the form I get the dialog box
with
SCC_Enrollment_PDP_200706.Organization Name.

I have 2 tables=SCC_Enrollment_PDP_200706 &
SCC_Enrollment_PDP_200707. I
changed the 200706 to 200707 and voila...Dialog box!!!

I can't see where it references the 200706 table. Here is the SQL
for the
query:
SELECT SCC_Enrollment_PDP_200707.State,
SCC_Enrollment_PDP_200707.Enrolled,
SCC_Enrollment_PDP_200707.County,
SCC_Enrollment_PDP_200707.[Contract ID],
SCC_Enrollment_PDP_200707.[Organization Name]
FROM SCC_Enrollment_PDP_200707
WHERE (((SCC_Enrollment_PDP_200707.State) Like [forms]![frm_State]
& "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.County) Like
[forms]![frm_State] & "*" & [txt_Other1] & "*")) OR
(((SCC_Enrollment_PDP_200707.[Contract ID]) Like
[forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.[Organization
Name])
Like [forms]![frm_State] & "*" & [txt_Other1] & "*"));

The query works correctly, I just don't want to see the dialog box.
Any help
will be greatly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
L

loudawg

Hey John,

The query runs fine on its own. It is only when I try to open the form, that
I get the dialog box.

I have searched high and low to find where it's referencing or think it's
referencing the 200706 instead of 200707 table.

Thanks

John Spencer said:
If you copied the SQL from the query (View: SQL)
-- Pasted the SQL into a NEW query
-- and run the query outside the form
-- and still have the problem with the query, then I am stumped.

On the other hand if the query runs without the prompt then I suspect that
the form references
SCC_Enrollment_PDP_200706.Organization Name
someplace. - in a filter, a form control, in an order by)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

loudawg said:
No filters...it worked fine before I changed the table...It used to be the
200706 table, then I changed it to the 200707 table.

If that was the problem, it should have prompted for each field. Ah!!!!
Venting.

Thanks again for your help.

Ofer Cohen said:
In the query you might have a filter defined and this is why you get the
message.
Open the query properties and check the filter poperty

--
Good Luck
BS"D


:

Ofer,
The field exists. That's one of the first things I looked at. I have no
idea
why it keeps referencing the 200706 table when I've changed it to
200707
table. I can't find where it thinks it lost the "field"

I made the change you suggested, but I still get the dialog box.

Thanks for your help, but I am stumped.

:

1. Make sure that the field [Organization Name] exist in the table
2. Also, are you sure the query works with this criteria
SCC_Enrollment_PDP_200707.State Like [forms]![frm_State] & "*" &
[txt_Other1] & "*"

When the field name is not connected to the string, instead try
SCC_Enrollment_PDP_200707.State Like "*" &
[forms]![frm_State]![txt_Other1]
& "*"

chaging all the crieria's

--
Good Luck
BS"D


:

I've read almost all the msg for the above, but I haven't found a
solution to
mine.
Which is...
A have a form=frm_State, when I open the form I get the dialog box
with
SCC_Enrollment_PDP_200706.Organization Name.

I have 2 tables=SCC_Enrollment_PDP_200706 &
SCC_Enrollment_PDP_200707. I
changed the 200706 to 200707 and voila...Dialog box!!!

I can't see where it references the 200706 table. Here is the SQL
for the
query:
SELECT SCC_Enrollment_PDP_200707.State,
SCC_Enrollment_PDP_200707.Enrolled,
SCC_Enrollment_PDP_200707.County,
SCC_Enrollment_PDP_200707.[Contract ID],
SCC_Enrollment_PDP_200707.[Organization Name]
FROM SCC_Enrollment_PDP_200707
WHERE (((SCC_Enrollment_PDP_200707.State) Like [forms]![frm_State]
& "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.County) Like
[forms]![frm_State] & "*" & [txt_Other1] & "*")) OR
(((SCC_Enrollment_PDP_200707.[Contract ID]) Like
[forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.[Organization
Name])
Like [forms]![frm_State] & "*" & [txt_Other1] & "*"));

The query works correctly, I just don't want to see the dialog box.
Any help
will be greatly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
L

loudawg

I found the problem. I guess from looking at it way too much yesterday that I
thought by running the query outside the form also gave me the parameter
dialog box.

After looking at you response further, I went to the subform, (which I
forgot to mention here). The subform had the incorrect refernce to the 200706
table.

Question: Why doesn't that get updated when a table is changed?

Thanks again!

John Spencer said:
If you copied the SQL from the query (View: SQL)
-- Pasted the SQL into a NEW query
-- and run the query outside the form
-- and still have the problem with the query, then I am stumped.

On the other hand if the query runs without the prompt then I suspect that
the form references
SCC_Enrollment_PDP_200706.Organization Name
someplace. - in a filter, a form control, in an order by)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

loudawg said:
No filters...it worked fine before I changed the table...It used to be the
200706 table, then I changed it to the 200707 table.

If that was the problem, it should have prompted for each field. Ah!!!!
Venting.

Thanks again for your help.

Ofer Cohen said:
In the query you might have a filter defined and this is why you get the
message.
Open the query properties and check the filter poperty

--
Good Luck
BS"D


:

Ofer,
The field exists. That's one of the first things I looked at. I have no
idea
why it keeps referencing the 200706 table when I've changed it to
200707
table. I can't find where it thinks it lost the "field"

I made the change you suggested, but I still get the dialog box.

Thanks for your help, but I am stumped.

:

1. Make sure that the field [Organization Name] exist in the table
2. Also, are you sure the query works with this criteria
SCC_Enrollment_PDP_200707.State Like [forms]![frm_State] & "*" &
[txt_Other1] & "*"

When the field name is not connected to the string, instead try
SCC_Enrollment_PDP_200707.State Like "*" &
[forms]![frm_State]![txt_Other1]
& "*"

chaging all the crieria's

--
Good Luck
BS"D


:

I've read almost all the msg for the above, but I haven't found a
solution to
mine.
Which is...
A have a form=frm_State, when I open the form I get the dialog box
with
SCC_Enrollment_PDP_200706.Organization Name.

I have 2 tables=SCC_Enrollment_PDP_200706 &
SCC_Enrollment_PDP_200707. I
changed the 200706 to 200707 and voila...Dialog box!!!

I can't see where it references the 200706 table. Here is the SQL
for the
query:
SELECT SCC_Enrollment_PDP_200707.State,
SCC_Enrollment_PDP_200707.Enrolled,
SCC_Enrollment_PDP_200707.County,
SCC_Enrollment_PDP_200707.[Contract ID],
SCC_Enrollment_PDP_200707.[Organization Name]
FROM SCC_Enrollment_PDP_200707
WHERE (((SCC_Enrollment_PDP_200707.State) Like [forms]![frm_State]
& "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.County) Like
[forms]![frm_State] & "*" & [txt_Other1] & "*")) OR
(((SCC_Enrollment_PDP_200707.[Contract ID]) Like
[forms]![frm_State] & "*" &
[txt_Other1] & "*")) OR (((SCC_Enrollment_PDP_200707.[Organization
Name])
Like [forms]![frm_State] & "*" & [txt_Other1] & "*"));

The query works correctly, I just don't want to see the dialog box.
Any help
will be greatly appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Top