Filter all with form

[SHotte]

I'm trying to get all data in a query using a form filter
(combo box)? When user choose a string in the combo box,
the filter is apllied in the query but when the user is
entering nothing in the combo box nothing appears in the
query. My question is how to have all the data when user
left the combo box blank?

Thanks,
Stephane Hotte

 

[Dennis Schmidt]

Hi Stephanie,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

The following Knowledge Base article should get you going in the right
direction:

ACC: Showing All Records (Including Null) in a Parameter Query

http://support.microsoft.com/default.aspx?scid=kb;en-us;10318

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support