Update multiple Combobox Row Sources utilizing a Global Variable

[jaykellogg]

I have a form with a tabbed control on it. Each tab has a form, with subforms, on it.

The main form (frmBid) is opened to a specific record (BidID).

Is there a simple way to limit the comboboxes to only show records containing BidID for the open bid?

I've tried using the Criteria area of the Query Builder by entering: [Form_frmBid].[BidID] and I've also tried using globBidID (declared as a Global variable). But, I haven't had success with either method.

 

[pbaldy]

The first should work, but you'd need a valid reference to the combo, and of course the form would have to be open:

http://www.mvps.org/access/forms/frm0031.htm

You can't refer to a variable outside of VBA, so you'd either need to have a public function that returned the value of the variable, or use a TempVar.

 

[jaykellogg]

Thanks for the link. That helped me figure out what I was doing wrong. I needed to use: [forms]![frmBid]![BidID]