Brad-
See TimeTool_V5All.zip that I just uploaded. The combo box now has an "<All
Customers>" selection that resets the combo box back to Null. You might need to
modify your code to recognize the Null as a request for no filter.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bradley
Sent: Tuesday, November 29, 2011 10:10 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Adding an "ALL" option to a combo box list
Hello, I am having trouble adding an "ALL" option to a combo box list. I have
spent half the day using suggestions from the web, but with no luck. I put a
test database in the "PTS Time Tool" folder and named it TimeTool_v5. The form
with the combo box is named frmIndividualReport3, and the combo box is named
cboCustomerName. This is what I want to do: The form uses combo boxes to collect
a date range, Function, and Customer as input to a report. I would like users to
be able to select "ALL" from the Customer combo box list to show all the
customers for a particular date range and function. I use Access 2007 and my
experience level is beginner. Thanks for your help.
Brad
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar