Mainform/Subform and Report

[Abdulaym]

Good day, trust we are all doing great.
Please I want the current Customer_ID in my form to display first in my report.



Or if there is a way I can have a search textbox and button which will enable me to search any Customer_ID in my Report. Thanks

[pbaldy]

Is this what you're looking for?

http://www.baldyweb.com/wherecondition.htm

Or when you say "first" are you wanting some type of special sorting?

[Abdulaym]

Thanks for your respond, is my subform second form?

[pbaldy]

You haven't clarified your goal, but if you wanted to open the report filtered to the record shown on the form you'd use the technique in the link, but using OpenReport with the appropriate arguments instead of OpenForm.

You seem to have added to your post, or I missed it. I imagine you could have a search textbox on your report, but it would have to be opened in Report view, not Preview.