By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,248 Members | 882 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,248 IT Pros & Developers. It's quick & easy.

display parameter on report?

P: n/a
MJ
Hi,

I'm hoping this is relatively easy.

I have a report based on a query - when you run the report, a form
opens up and you are prompted for a date range. These are combo boxes
(ie. January 2003, February 2003, etc). The combo boxes display the
date field but the field that is actually sent back to the query is
the corresponding identifier (ie. 1 for January 2003, 2 for February
2003) etc.

I can display the parameter on the report but it displays as the
identifier. How can I get it to display what is in the combo box (ie.
January 2003 instead of 1)?

I don't know if I explained this very well, but any help would be
greatly appreciated!

MJ
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Add to the code you're using to send the parameter to the report to the column
property of the combobox:

NameOfCombobox.Column(1)

Note -- it's column 1 because the columns are zero based!
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"MJ" <mj****@excite.com> wrote in message
news:a5**************************@posting.google.c om...
Hi,

I'm hoping this is relatively easy.

I have a report based on a query - when you run the report, a form
opens up and you are prompted for a date range. These are combo boxes
(ie. January 2003, February 2003, etc). The combo boxes display the
date field but the field that is actually sent back to the query is
the corresponding identifier (ie. 1 for January 2003, 2 for February
2003) etc.

I can display the parameter on the report but it displays as the
identifier. How can I get it to display what is in the combo box (ie.
January 2003 instead of 1)?

I don't know if I explained this very well, but any help would be
greatly appreciated!

MJ

Nov 12 '05 #2

P: n/a
MJ
I'm not following... where do I put that?

I put a textbox on my report and put the following property for it:
=[Forms]![prompt]![startmonth].Value

This displays 1 (for January 2003).

How do I get it to display January 2003 instead of 1? Thanks!


"PC Datasheet" <sp**@nospam.spam> wrote in message news:<ww*******************@newsread1.news.atl.ear thlink.net>...
Add to the code you're using to send the parameter to the report to the column
property of the combobox:

NameOfCombobox.Column(1)

Note -- it's column 1 because the columns are zero based!
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"MJ" <mj****@excite.com> wrote in message
news:a5**************************@posting.google.c om...
Hi,

I'm hoping this is relatively easy.

I have a report based on a query - when you run the report, a form
opens up and you are prompted for a date range. These are combo boxes
(ie. January 2003, February 2003, etc). The combo boxes display the
date field but the field that is actually sent back to the query is
the corresponding identifier (ie. 1 for January 2003, 2 for February
2003) etc.

I can display the parameter on the report but it displays as the
identifier. How can I get it to display what is in the combo box (ie.
January 2003 instead of 1)?

I don't know if I explained this very well, but any help would be
greatly appreciated!

MJ

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.