Update Data as MDB window looses focus

[RobGMiller]

Access 2000
Two windows with MDBs loaded accessing the same data recor
Need to refresh the data as one window looses focus so that the same record can be manipulated from the other window

Thanks in advance,

 

[Mark]

Look up the Forms Refresh method.

i.e.

Me.Refresh - enter in the forms Lost Focus Event

HTH

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/

Access 2000,
Two windows with MDBs loaded accessing the same data record
Need to refresh the data as one window looses focus so that the same

record can be manipulated from the other window.

 

[RobGMiller]

Thanks for the repl

That's the first thing I tried. Unfortunately, the OnLostfocus or OnDeactivate events do not fire when moving off the form or the database for that matter. The OnDeactivage event only fires when the database is closed

Any idea what will make the OnLostFocus event fire?