Autoform Nav Button Event

Hello,

I am making updates to an existing access application created by someone else a while back. I am a programmer by trade, but have limited experience with access and VBA.

What I am trying to do is tie some controls to the autoform nav buttons so when the user is moving through records the controls will be updated with the current records information. Something along the lines of an autoform.navarrow.click event.

The information I need to display comes from various other tables with one to many relationships. Not sure if this is the best way to go about handling this.

Would it be better to recreate the autoform based off of a query that does a join of the necessary tables? Think a customer table, items table and a purchases table(customer.id, item.id, date, quantity etc...)


Two other questions

1. Is there an event for tabs similar to onclick? So when I am clicking through tabs it will fire off an event.

2. I would like to fire off an event based on the current record in the autoform, how do I get that event to fire off when the form loads? I tried in form_load but it won't work. I am assuming because I am tying into the records ID, which isn't available until after the form loads.

Thanks,