Tab Name / Tab Query 1

[swtrader]

I've never used tab controls before. Have several tabs including: Contacts and PhoneInfo .

I don't understand (a) what the specific syntax is for a requery on cboIndividual on the PhoneInfo tab, and (b) where I put the requery.

Thanks.

 

[LisaWay]

You requery a combo box on a tab control the same way as if it were directly on the form itself (with no reference to the tab control):

[cboIndividual].Requery

You decide where to put the requery based on what event should trigger the requery. If you're using the combo as a way of looking up and navigating to a particular record, it's usually a good idea to requery the combo when it gets the focus.

Regards,
Lisa

 

[swtrader]

Incredible! It always seems so simple when you know how to do it. GotFocus Event -- and very direct and simple syntax. Why didn't I think of that?! Have struggled with every form and combobox I've build over the last 2 years trying to get them to requery. And I think this would have worked in most -- if not all -- situations. Thanks very much!

swtrader
-- If you don't know where you're going, you'll always know when you're not there.