Populating unbound textboxes when Navigation Bar is used

[Sunnray]

I've been unable to find what I'm looking for using Google.

I have a form with a dozen fields bound to a table. I can cycle thru the records no problem. I also have another dozen fields I want populated whenever the key changes. This code is in the form_load event and works fine but I don't know what event it goes in for it to trigger when the navigation buttons are used.

Is that clear enough?

 

[boblarson]

Use the Form's On Current event.

 

[Sunnray]

That's it. Thanks a bunch.

 

[missinglinq]

Also note that you can remove your code from the Form_Load event. This type of code in the Form_Load only applies to the first record when the form loads, as you've apparently found out, and the Form_Current event will not only fire when moving from record to record, but will fire and be applied against the first record when the form loads.

Linq ;0)>

 

[Sunnray]

Also note that you can remove your code from the Form_Load event. This type of code in the Form_Load only applies to the first record when the form loads, as you've apparently found out, and the Form_Current event will not only fire when moving from record to record, but will fire and be applied against the first record when the form loads.

Linq ;0)>

Thanks Linq