How to force a Form to update ?

[Will]

I have 2 forms on the same table...
- One is Data Sheet View
- 2nd is Justified

Both forms are open...

When I add a new record using the Justified Form I want the Data Sheet View
to update to show that new record.

I tried to use an "After Update" Evant and a Macro to "requery" the
frmDataSheet but that doesn't seem to work.

How can I get the Data Sheet Form to update after I add a new record using
the Justified Form?

- If I can do it with a Macro... how?
- If I must create VBA code can anyone give me a code snippit?

thanks for any help.

 

[Wayne Morgan]

When doing a Requery in a macro, it allow you to enter a control name to
requery. I tried entering a form name but it errors when running the macro.
This can be done in VBA though.

Example:
Forms!FormName.Requery