Richard,
I have a form set up (continuous) and in the header I have combo boxes set up to do searches.  I can select a Description, or Account Name, or SubAccount Name, push my Search button and the form shows me the results.  Works great.  The combo's names are DescSearchcbo, AccountSearchcbo, and SubaccountSearchcbo.

I have another button to open a report based on the forms underlying query, so I get a nice clean report showing how much I spent at the Piggly Wiggly, or by the Groceries acct, etc.  The report opens up and shows the filtered results beautifully.

The problem is this: I have a label the says "Search Results for:" and a text box next to it (SearchTitletxt).  I want this text box to display the value from whatever combo I picked to base the report on.  So if I used the DescSearchcbo to search for Piggly Wiggly, you would see "Search Results for: Piggly Wiggly" when the report opens (or the acct name, etc).

I've put my code in the on click event to open the report, but I keep seeing "can't find SearchTitletxt".  I placed it in the On Open event, but get a dialog box saying "Enter Parameter".
Here is my code:
If Forms!RegisterF!PayeeSearchcbo.Value > "" Then
        Me!SearchTitletxt.ControlSource = Forms!RegisterF!PayeeSearchcbo.Column(1)
    End If

I think this has something to do with loading the value befor the report is "created".  Or I'm just a little loopy.

Can you advise me on this please?

Thanks,
Don

---

Reply from Richard Rost:

Report timing is funny like that. Try going the other way. Put an unbound text box in your report that reads the value off of the form. Control source =

=IIF(IsNull(Forms!RegisterF!Combo),"",Forms!RegisterF!Combo)