Requerying one form from another

  • Thread starter Thread starter jonesy
  • Start date Start date
J

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
 
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

jonesy said:
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
Click to expand...
 
Back
Top