View Full Version : A dumb one


Stabu
12-09-2000, 07:17 AM
Just discovered the use a form with combo boxes to specify queries. Very cool and all is well there. Now I want to do something else with it. I have a report that has a header which describes it. ie; Training Due Next ___ Days. I would like to put that day value from the combobox where the blank is so I don't need 10 different reports just because of a header. I tried using the same [forms]![form]![combobox] formula in a text box in the blank but all I got was a -1 value. Any ideas, Thanks!!

Richie
12-09-2000, 09:46 AM
Yes you can providing the form is open when the report is opened, but you have to refer to the column that contains the value you want i.e. =[forms]![form]![combobox].column0

Pat Hartman
12-09-2000, 04:56 PM
The column number is an index -
=[forms]![form]![combobox].column(0)

Stabu
12-10-2000, 03:56 AM
Got It, HEE HAA!!!!! Thanks