Parameter Value Dialogbox

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

Guest

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.
 
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
 
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...
 
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...
 
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...
 
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...
 
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...
 
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...
 
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...
 
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...
 
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...
 
Back
Top