Set Access to automatically update

[harrytgs]

You can just read the last paragraph - that has the whole question, the rest is just background!

I am using Access 2007 and am making a pretty complicated database with a subform. This then sends some of the form names to the query which generates a report. All of this works fine except for one part. This is because there is a relationship shown below:

DB1 DB2
Ref No <-----> Ref No


Branch Branch

All the info is on DB1, and, once I enter the Ref on DB2 and close & reopen the form or go back and then forward records, the Branch automatically appears. The branch has to appear before the query works.

Can I get Access to update the table (with the Branch) without having to close & reopen (or refresh by pressing F5, which also works) - maybe a macro that refreshes once the Ref No has been updated?

[June7]

In the AfterUpdate event of the control (textbox?) maybe:

DoCmd.RunCommand acCmdSaveRecord
Me.Refresh

[harrytgs]

Thanks for your quick reply, june7!

I have been trying to use the AfterUpdate - just realised that I am doing it on the form and not the textbox!

Will try today and let you know.

[harrytgs]

This didn't work and kept erroring.

I have fixed this by making a macro which sends the F5 key on Update and all is now working.

Thanks for pointing me in the right direction!