My query works fine, Joseph - it's the report based on the query I'm getting
this weirdness on. I'm not sure what you mean by having a filter in a query -
but since I don't know how to do this, I'm assuming I haven't done so.
Any other thoughts?
--
Thanks for your time!
:
What does your sql look like? It should look like:
SELECT PtID, 'Patient: ' & [Lastname] &', '& [Firstname] &' ' & MRN as
PatientName
FROM PatientInfo
ORDER BY [Lastname];
This will give you two columns in your combo box. Make sure that in the
properties for the combo box you set the "Number of Columns" to "2" and
adjust the column widths to not display the the "PtID" column, ie "Column
Widths: 0";1.25".
Also if in your query you have placed a criteria to filter the data and the
query cannot find the location of that information, ie, referenceing a field
on a form (Criteria: Forms.Patients.PtID) it will show that error that you
are getting.
:
Yes, same thing is still happening.
I've tried removing JUST the control involved, & the report works fine.
I've tried putting the control back in as a combo box & still get the prompt
to enter parameter value.
I've tried putting the control back in as a text box & still get the prompt
to enter parameter value.
Now here's the REALLY strange thing - I try it without having this field at
ALL (neither as a text box nor as a combo box) & STILL get the prompt to
enter parameter value.
Please help???
--
Thanks for your time!
:
Are you still experiencing "weirdness" in your report or is it behaving? You
may need to work with a copy and start deleting controls and/or sections to
see if it makes a difference.
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm
:
My sorting/grouping expression is "Pt" - no table mentioned (sorry if I said
something misleading).
And thanks for pointing out the obvious (duh)... There's a blank space under
"filter" in the properties for the report.
Again, thanks for your time.
--
Thanks for your time!
:
Why isn't your sorting and grouping expression just the field name
[pt]
You shouldn't need any table names unless you had two fields in your
report's field list with the same name (never a good idea).
You will find the report's Filter property in the report's properties (how's
that for stating the obvious)?
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm
:
Yes, Duane, the field/expression is in the sorting & grouping & "points" to
where I'd expect it to there (ie to Pt).
I've double-checked the control sources, and they seem fine.
I haven't checked the filter property & don't know how to do so.
And thanks for the reassurance on the &/+ issue.
Thanks for your help & time!
--
Thanks for your time!
:
Do you have this field/expression in the sorting and grouping dialog? Have
you checked all control sources and the Filter property?
BTW: it is most proper to use "&" (as you have) rather than "+" to
concatenate text values.
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm
:
Thanks for the suggestion, but I'm still getting the parameter query,
probably because the expression comes from fields in a table or something.
I'm hoping one of the MVPs will pick up on this thread & let me know why
this seems to happen sometimes - I can't figure out what I'm doing that leads
to this situation.
--
Thanks for your time!
:
I did something similar in my report. I have the query with the items I want
to show in the report i.e. [lastname],[firstname],[MRN]
then in the report i put something like the following as the control souce
of my text box:
=[lastname]+", "+[firstname]+" "+[MRN]
I hope this helps.
:
I've tried to insert a field in my report.
The field is drawn from a query.
The field in the query is pulled from a table that contains these fields:
PtID (autonumber, primary key)
LastName (text)
FirstName (text)
MRN (text)
I want to include LastName, FirstName, & MRN on my report. My preference
would be to use a cancatenated expression:
Patient: [lastname] & ", " & [firstname] & " " & [MRN]
I have created that expression as a field, Pt, in my query, and have tried a
variety of ways to get it to display in my report. Finally, using a combo
box, it displays correctly. BUT... when I run the report, the following
"enter parameter value" dialog box pops up:
Lookup_Pt_ID.Pt
If I blow by that (say OK), the report looks just like I want it.
I've seen this phenomenon before & it puzzles me - I'm getting this dialog
box & (a) don't know how to get rid of it and (b) don't know why, if it's
asking for a parameter value, the darn thing WORKS.
Any help would be hugely appreciated.
