Is This Possible

[cyd44]

I have a form which has options to query another form selecting either current records or all. As an example:-

Opt1 = Query by Location (current)
Opt 2 = Query by Location (all)

Each of the above has a seperate form query where I have set the criteria on the location field to forms!bookingform!combobox

The qry for opt 1 also sets DateofBooking Field criteria as >=Date()

I am using the same combo box for both options and the only difference in the form queries are the addition of the Date() criteria for qry1.

When I run the queries Opt1 returns the correct information and Opt2 is blank.

Am I trying to do the impossible here?

 

[Simon_MT]

One way would be to change the Record Source of the combi-box depending if it Option 1 or 2.

Simon

 

[cyd44]

Hi Simon

Thanks for getting back to me. I have now got it to work how I intended. I did not want to create another combo box but wanted to use the same for both options. The errors were down to me with a typo.

Thanks anyway for a prompt response.