interchangings rowsources

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello there,

I have a form where users select values from a series of combo boxes to
build a query.

At present each combo box is independent. I have set up these combo boxes
to be dependant on the value entered in specified boxes to narrow the
selection choices to only relelvant options.

Problem:

I want to be able to say: If comboBox A is blank, then use Query1,
otherwise use Query2

I want this to occur as the user clicks on the combo box.

Suggestions?

Many thanks.
 
Carlee said:
Hello there,

I have a form where users select values from a series of combo boxes
to build a query.

At present each combo box is independent. I have set up these combo
boxes to be dependant on the value entered in specified boxes to
narrow the selection choices to only relelvant options.

Problem:

I want to be able to say: If comboBox A is blank, then use Query1,
otherwise use Query2

I want this to occur as the user clicks on the combo box.

Suggestions?

Many thanks.
Click to expand...

This article at the Access Web shows two ways to go about it:

http://www.mvps.org/access/forms/frm0028.htm
 
Hello there,

I have a form where users select values from a series of combo boxes to
build a query.

At present each combo box is independent. I have set up these combo boxes
to be dependant on the value entered in specified boxes to narrow the
selection choices to only relelvant options.

Problem:

I want to be able to say: If comboBox A is blank, then use Query1,
otherwise use Query2

I want this to occur as the user clicks on the combo box.

Suggestions?
Click to expand...

look at your second question and use the same approach
 
Back
Top