Combo Box "

[Bill]

Hi,

I need your help.

I have no problem with running a report by choosing one country after I
click Preview Button. When I want to leave it blank and make combo box
(country) into visible. That means I want all countries on the report.

I set the code on query like "[Forms]![frmcountry]![cboCountry]". If I
want all countries, how I disable "[Forms]!frmcountry]![cboCountry]" in
order to get all Countries on the report.

Your help would be much appreciated.

 

[Ken Snell]

[Forms]![frmcountry]![cboCountry] Or [Forms]![frmcountry]![cboCountry] Is
Null

 

[Mingqing Cheng [MSFT]]

Hi Bill,

I haven't heard back from you yet and I'm just writing in to see if you
have had an opportunity to try MVP's resolution. If you could get back to
me at your earliest convenience, we will be able to go ahead.

If you encounter any questions or concerns, please feel free to post here.
I look forward to hearing from you.

Thank you for your patience and cooperation.



Sincerely yours,

Mingqing Cheng
Microsoft Online Support