In the click of the CommandButton next to the Combo:
cCompVal = ALLT(This.Parent.DisplayValue)
REPORT FORM myreport TO PRINT FOR mytable.field = cCompVal
>I want the user to make a choice in the combo, press a button next to it, and in the click event, have code that runs the report. the report then will print only the records that have a field that match the combo selection. (the field will of course be specified in the print when)
>
>
>>Jimmy, can you be more specific? Do you want the report to automatically print? Or print a range of records based on the combobox selection? Or only allow the user to select a Print command when the combobox has a certain selection?
>>
>>>I want to tell a report to "print when" a condition is true in a combobox on a form. How is this done?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05