"Record Focus" Code....or something.....

[commandolomo]

Hello All

As the 'FormLoad' vba runs code when the form is loaded, does anyone know if there is an equilivant peice of code for 'Record Load'? I have a form driven db, where users only have access to the forms - as all good db's should be!

What I want to do is run a bit of code everytime a new record is displayed on a form, and I have tried to use FormLoad and OpenForm modules, but these only run the code the first time the form is loaded/opened, and not everytime a new record is displayed - which is what I want!

Any ideas?

PJL

 

[ColinEssex]

Use OnCurrent event

Col

 

[KenHigg]

Have you tried OnCurrent()?

kh

 

[ColinEssex]

Just beat you there Ken

Col

 

[KenHigg]

You too darn fast for me today!

 

[commandolomo]

Damm you guys are good!

Cheers fellas, and good to see a bit of the old 'fastest finger first'!!!

PJL

 

[ColinEssex]

Damm you guys are good!

I wish