Requery Form Data

[Guest]

I have a tab control and form in each tab control. I want it to requery
anytime I click on a tab control for another form, so I updated record A that
was showing in tab control 1 (form 1) and when I click tab control 2, it will
the show that record, which I did something to make it show up in there, like
account status, etc. I tried the on click for the tab control button, but
nothing works except shift 9... I created a Requery macro & left control name
blank....

Thanks
Curtis

 

[kingston via AccessMonster.com]

Have you tried using an event on the individual forms? Assuming the forms
exist only in the tab control (i.e. they aren't used as stand-alone forms),
you can use the event AfterUpdate to requery the other forms. Otherwise,
you'll need to check the context in which the form was updated before
executing a requery.