Double-Bound Combo Box

[ltelfer]

I'm using Access 97...

I've get a combo box (cb) that I would like to be bound to one of two queries. I'd like the binding to be determined by a couple of buttons on the form where the cb appears. Also I'd like th cb to default to one of the queries if niether button is pressed...

Any ideas? Anything will help...

Regards
LT

 

[Mile-O]

I've get a combo box (cb) that I would like to be bound to one of two queries. I'd like the binding to be determined by a couple of buttons on the form where the cb appears. Also I'd like th cb to default to one of the queries if niether button is pressed...

Few things. Are you sure you don't mean its RowSource rather than being bound? They are separate concepts.

On the click of a button, you'd just say:

Me.MyCombo.RowSource ="MyQuery"

Set it's Default RowSource to the query you want as the default.