Event Procedures Argggghhh!!!!!

[naminder]

I can't seem to find one that will do what i want.

I have a tabbed interface. Tab one has details about that record e.g. clients
Tab two is an input form that lets you add new client

Basically after i added the client i want to go back to view this record in the first tab. i can put a button with Me.Requery, works fine.

Is there an Event Procedure on the form i can use to do this automatically?

Anyone got any good links to event procedures explanations.

 

[FoFa]

When the new record is added, why not just requery the other form there?

 

[RuralGuy]

You will get a TabCtl Change event every time you switch tabs.

 

[naminder]

The Chnage Event on the Tab won't work because it requeries all the records on the form. so my combo box is wrong and the record i was on is reset. You have to use the combo box again to find the record.

It's the related records on the form on my tab i want to requery. At the moment the only way it works is as before putting a command button with me.requery on that form

If i use the On Timer event - Me.Requery
Interval - 5000

Would this cause it to slow too much? We run on a large citywide corporate network

Found A Solution

I created a Save Button on second tab then on click event put
Me.Parent![sfrmClientBeds].Requery

This worked. But would still love to know why the on Get Focus, On Activate events never seem to do much. When are they used?

 

[RuralGuy]

I suspect putting Me.sfrmClientBeds.Requery in the TabCtl Change event would have worked as well.

 

[naminder]

I thought it would too, but didn't. i put it in the onclick event of the tab button