prompted to enter parameter value 1

[mishmish]

Hi,

I keep getting prompted to enter a value for a field when I run a report. In my sql I'm joining on two tables with a common field of a recipient id field. This is what I'm prompted to enter--the recipient id.

The query selects records from other queries. This is the query below. Does anyone know why this would happen?


"SELECT qryGetLessthanMaxDateRecs.*, qryGetMaxDateRecs.*, qryGetLessthanMaxDateRecs.fld_Status, qryGetMaxDateRecs.fld_Status
FROM qryGetMaxDateRecs INNER JOIN qryGetLessthanMaxDateRecs ON qryGetMaxDateRecs.fld_RID = qryGetLessthanMaxDateRecs.fld_RID
WHERE (((qryGetMaxDateRecs.fld_Status)<>[qryGetLessthanMaxDateRecs]![fld_Status]));&quot;

Thanks,
mishmish

 

[JoeMiller]

The query you are executing doesn't know how to interpret the WHERE clause in your criteria. Look at this section here:

[tt]
WHERE (((qryGetMaxDateRecs.fld_Status)<>[qryGetLessthanMaxDateRecs]![fld_Status]));&quot;
[/tt]

[qryGetLessthanMaxDateRecs]![fld_Status] is the part it's having trouble with, it doesn't know how to interpret it. So if you get the query to figure this out the parameter input won't pop up.




Joe Miller
joe.miller@flotech.net

 

[mishmish]

Hi Joe,

Thanks for your answer and I think I understand what you're saying. But, I did try to take out the where clause (just to test) and I still received the same prompt so I'm thinking it must be something else. When I execute this query by itself (not in the form), it returns the correct records.

Any ideas?
mishmish

 

[JoeMiller]

In your first post you said a report.. now you are saying a form? I'm confused, I am going to assume you meant a report. If the query itself runs ok, then the next things to check are a mispelled ControlSource in a text box or in the Sorting and Grouping a mispelling or field that doesn't exist. The popup happens when Access can't figure out what field you meant when you typed in a ControlSource. Joe Miller
joe.miller@flotech.net

 

[Guest_imported]

I have the same sort of problem...I've deleted some fields out of a sample database that came with Access and now everytime I open up the form through the switchboard it yells at me and askes for parameters of the things I previously deleted...I need help too...

 

[Mikethered]

I have a moderately complex query which is the basis for a report. The query has two parameters for which it should prompt.

If I run the underlying query, Access prompts for the two parameters, then prompts for them a second time.

However, if I run the report based directly on this query, Access correctly prompts only once for each parameter.

This, and other related postings, suggests Access has a bug an the way it handles prompting for query parameters.

I would welcome other suggestions.

 

[Quintios]

Cara-

The form is either sorting or filtering records when you open it up by the fields that you deleted. You'll have to go into form design mode to try to figure out what fields it's looking for.

If you give me more info I can help. What sample database was it, what fields did you delete, and what form is asking for more info?

Onwards,

Q-