Sub Form Functions

[Sharkbyte]

When doing a requery, of a subform, what functions - on the subform - are
being called?

I would like to run a small piece of code whenever the subform is requeried,
or when the user moves between records.

Thanks in advance.

 

[Gina Whipp]

Sharkbyte,

The answer depends on where you put the requery. If you are trying to run
some code everytime you change records you would place your code in the
On_Current event of the form. If you want the code to run when a record is
changed or altered then place it in the On_Dirty event of the form.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm