Requerying one form from another

[jonesy]

Form 1 opens form 2.
In form 2 I update data underlying form 1.
When I close form 2 the data in form 1 is unchanged
whatever I try to do to requery it eg
[Forms]![form 1].Requery

Even closing form 1 and re-opening it (all from form 2)
does not do the trick

Its driving me crazy

 

[Arvin Meyer]

Assuming that there isn't a locking conflict, try explicitly saving form 2
first.

DoCmd.RunCommand acCmdSaveRecord
[Forms]![form 1].Requery
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Form 1 opens form 2.
In form 2 I update data underlying form 1.
When I close form 2 the data in form 1 is unchanged
whatever I try to do to requery it eg
[Forms]![form 1].Requery

Even closing form 1 and re-opening it (all from form 2)
does not do the trick

Its driving me crazy