refreshing a form from a second form (not subforms)

[qwertybob]

i need to be able to refresh the data on a form, when i click a button in a second form.

the onclick events runs some sql that alters the data that form a is based on, then closes form b. The changes are not reflected on form a until the form is reopened or i use a button on the form a to refresh.

is there anyway to achieve this? surely there must be an easier way than closing a form and reopening?

thankyou.

 

[ChrisO]

How about something like this: -

Forms("a").Requery

Hope that helps.

Regards,
Chris.

 

[qwertybob]

that would have been fine except i forgot to mention that 'form a' uses a filter that obtained data from a third form and i would like to avoid keeping the third form open, sorry for not being clear.

thankyou for your help

 

[ChrisO]

Well OK but I’m still only on my first coffee…

If I read this correctly

The changes are not reflected on form a until the form is reopened or i use a button on the form a to refresh.

then you already have code called by a button that does the job. If that is correct then why not call that code from form b?

Apart from that can you please post a small A97 version of the setup you have?

Regards,
Chris.