Updating embedded report using dynamic created SQL statement

[podrae]

Hi Guys



I have created a database and have a form (searchpartsfrm) with multiple combo boxes and a text box that builds up all the entries and creates a perfect SQL statement and stores this in strisql variable.

I have a report (showallpartsrpt) embedded on the page that is currently showing every record in the database.

Is there anyway to have this form "refresh" and show only the results of the query by clicking a "search" button?

I believe I need to use the filter command somehow but im not sure how to reference the embedded form. If I try with some test code it cannot locate showallpartsrpt.

[orange]

Here's a recent youtube video that may help.

[ItsMe]

Here's a recent youtube video that may help.

That's a good video.

[orange]

Yes. It's quite new and very clear --good voice and recording.
Steve has a number of Access related videos on youtube.
He posts here from time to time.

[podrae]

Man legend, That was exactly what I was looking for and clear enough that I actually learnt something rather than copy pasting.