Automatically updating a form while open

[Guest]

Hi,
I have a form that has two tabs on it. One tab shows existing records, the
other tab is to add new records. If I add a record it won't show up on the
other tab unless I close out of the form and then reopen it. I tried to do a
me.form.refresh on the tab, but it didn't work.

Any suggestions on how to do this would be greatly appreciated.
Thanks,
krista

 

[Guest]

Try this:

Add this to the AfterUpdate event for the form:

RunCommand acCmdSaveRecord
Me.Requery


Does that work for you?

 

[Pieter Wijnen]

Better is:
Me.Dirty = False
Me.Requery

Pieter

Try this:

Add this to the AfterUpdate event for the form:

RunCommand acCmdSaveRecord
Me.Requery


Does that work for you?