Drop Down menu on report

  • Thread starter KimTong via AccessMonster.com
  • Start date
K

KimTong via AccessMonster.com

Hi,

I have a drop down menu from table Week (Date, Noofweek) on 'DropDown Form'.
I'd like to put the field Date on my header report name 'Weekly Report'. Is
anybody can give me a clue to do that?.
Thank you in advance
 
A

Allen Browne

If the form is named Form1, and the combo is Combo2, and the form remains
open behind the report, you can display the value of the combo by adding a
text box to the report, and setting its Control Source property to:
=[Forms].[Form1].[Combo2]

If the first column of the combo is zero-width, you may need to specify the
value from the next column. Since the first column is zero, that would be:
=[Forms].[Form1].[Combo2].[Column](1)
 

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

Drop down list and report 6
Report from drop down menu 5
Selecting a report from a drop down box 3
Date Format In A Report 2
How to get counts & totals from a drop-down list 9
multiple report parameters (one being dialog box with drop down) 3
on report open, query date 3
Change font color in report 2

Top