Populate subform datasheet combobox from tabcontrol combobox

[tstuve]

I have a product combobox that is part of a subform datasheet embedded in a tab control on the main form. I would like it to be populated based on a selection from a subcategory combobox that sits on the main form's tab control.

I can't get it to populate correctly, but when you try to add another record in the datasheet, the product list doesn't change. If I change the subcategory selection, the product list is is the same as in the first record.

Any ideas??

Thanks in advance.

 

[mdmilner]

Re: Populate subform datasheet combobox from tabcontrol comb

I'm suspicious that either Requery or Refresh methods will do the trick for you. I believe objects only go out and build their listvalues when they are intially opened (form opened and controls active) - to get new values, you'd have to Requery the record source.

Not sure if you'd have to requery the entire subform or if you could be more specific.

Mike

 

[tstuve]

Re: Populate subform datasheet combobox from tabcontrol comb

Thanks for your reply. I gave up on using a combo on the tab control, and put it in the header of the subform. Then I set the rowsource of the subform combo to load on the "got focus" event and that did the trick.

I thought the requery method should work too, but my syntax probably wasn't set up correctly, in retrospect.