Drop Down menu on report

  • Thread starter Thread starter KimTong via AccessMonster.com
  • Start date 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
 
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)
 
Back
Top