display parameter on report?

[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

[PC Datasheet]

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

[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