Which Event Works Best?

[colette]

Hi,
I have a form which has two separate subforms in it. When the user selects a record in the first subform, I want the values of that record to write to the second subform's fields. OnCurrent works when there is more than record in the subform. My problem is two fold, one I don't want my copy code to run when the form loads and I need it to copy a record when there is also only one record in the subform.

Which event do you recommend?

Also, does anyone have a suggestion on how to allow the user to tab through a form, but really only record by record (with the keyboard) and not having to go through all the fields before getting to the next record.

Thank you,
Colette

 

[Ron_dK]

I would use the 'on lost focus' event.

If you want to go to the next record go to :
tools > options> keyboard > move after enter and select next record.

Hope this helps.