Problem with dialog in double parameter query

D

Debra

This is a very simple query to select all fields for a specific recor
identified with two parameters. The query selects the correct record
however the dialog in the pop-up window that asks for the parameter
is goofy. Where it should say, "Enter field1 value" it show
instead, "Enter field1 value], 1 [Unknown]=[Enter". It does the sam
thing for the second parameter only changing the text (as it should
and the number 1 to 3. I know I've run across this sort of proble
before, but I can't for the life of me remember how to fix it

The SQL basically looks like this

SELECT TABLE.*, TABLE.FIELD1, TABLE.FIELD
FROM TABL
WHERE (((TABLE.FIELD1)=[Enter FIELD1 VALUE]) AN
((TABLE.FIELD2)=[Enter FIELD2 VALUE]))

I have other queries that both function the same and look the same
but work correctly
 
D

Duane Hookom

Could you paste your actual sql rather than "basically looks like"? I'm not
sure why you are selecting FIELD1 and FIELD2 twice.
 
D

Debra

By "basically" I mean that while I copied and pasted the SQL I di
change the names of the table and fields and the parameter promp
text.

This is actually not my database but a colleague's who comes to me fo
help when she hits a snag she can't figure out. If you think it wil
help, I can get another copy of her SQL and paste it again unaltere
as soon as she gets in this morning

I know I encountered this same situation, the parameter prompt tex
showing things I didn't put there, but it's probably been around
year ago. I don't now remember what I did that fixed it. I'm no
even sure I ever figured out why it happened, or if I just hit o
something that made it go away

I have a query in one of my programs that works the same way and th
SQL looks the same, but mine works exactly as expected. Here is th
SQL for mine

SELECT RFPS.*, RFPS.SANDSID, RFPS.RFPS_
FROM RFP
WHERE (((RFPS.SANDSID)=[Enter SANDSID]) AND ((RFPS.RFPS_V)=[Ente
visit number]))

I tried deleting in the SQL view the second instance of selecting o
the two fields which ask for parameters, but when you go back int
the query design grid Access puts them back

I don't know if this helps any, but in both queries (hers and mine
the two fields for which parameters are requested also comprise th
primary key

Edit: She's in now so here is the exac
text of her SQL

SELECT BAB_I.IDNO, BAB_I.BAB_NO, BAB_I.
FROM BAB_
WHERE (((BAB_I.IDNO)=[Enter baby's IDNO]) AND ((BAB_I.BAB_NO)=[Ente
baby number]))

She has the two parameter fields first and the "select all" wildcar
last, but we also tried rearranging hers to match mine, then mine t
match hers, with no difference in either one. I'm reasonably sur
the problem really isn't the query - the query is only exhibiting th
symptom, but I have no idea where to start looking or what we shoul
look at to try to find and fix the problem
 
D

Duane Hookom

If the parameters aren't as you expect them when attempting to view the
datasheet of the query then I expect your query might be corrupt. I assume
RFPS is a table and not a query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top