tabbed forms and combo box refreshing

[Guest]

Hello

I have what i call a 'maintenance' form which has 4 tabs on it. each of
these tabs has a subform for variable table maintenance than needs to be
done. my problem is, when a user adds a record in (say) tab 1, the combo box
in (say) tab 2 does not reflect the newly added (or deleted) record. I have
added me.subformXXX.requery on the tab clicks as well as the on got focus/on
enter for the combo boxes a me.requery but it seems that these do not work.
I did notice; however, that if i were to click around for a few seconds
(change selected record, jump between multiple tabs), that eventually the new
record would be available in the drop down.

is there a way to make this happen quicker without asking my end user to
'play' around for a few seconds (about 30)?

Thanks.
ben

 

[Guest]

Hi again,

Never mind. Seems the 'on got focus' event that i thought was there wasnt,
and it seems to be doing the trick. I dont quite get why all the other
requeries didnt work tho.

thanks again.
Ben