how to communicate with other forms

[Jerry Qu]

Hi All,

how can call an action from one form to another form, like pass a parameter
to or add a line to a list of another form?


TIA

Jerry

 

[rolaaus]

It is possible to pass a parameter in a the docmd.openform but I don't know
if it works when the form is already open.

Can you explain in more detail what exactly you are wanting to try and do?
It may help come up with the exact solution needed.

 

[Jerry Qu]

thanks,

for example, if we want

1. double click an item in a list box of form1 to add that item to a list
box of form2.
2. the parameter will be passed to form2, a recordset will be requeried to
reflect the new item.
3. if form2 is open, it will be refreshed to display the new item. if form2
is not open, it will be opened

....

TIA