refresh form's record source to update picture

[sparky23]

Hi,

I have an issue to manage my situation. Shortly:

a form contain only image frame, and is opened by another form to show a picture.
Form's record source is a query, and picture's control source is one filed in this query.
It works perfectly when I set criteria in main form and open one with the image, but the problem is now, when
I change criteria in main form, i would like to refresh the picture form instead to close it and open it again.
I have problem now to refresh form's and picture's record source.

Can someone help me.

Thank you

[June7]

Are you saying both forms have same data source - same table?

The picture form can have a RecordSource that references control on other form as parameter. Then code runs Refresh command on picture form.