combo Box with "All"

[Guest]

using combo box to allow user to select choices for report/query. I know how
to write the SQL to modify the query based upon the user choice using the
afterupdate event. What I'm having problems with is how to be able to offer
the Default choice of "ALL" for the initial form screen combo box with the
bound field from the combo box being a number field... I can get it to work
if I bind the combo box query to the text description field, but since I
really want to bind to the unique number for further query filtering, I'm
curious if there's a better way to do this...

 

[Dirk Goldgar]

using combo box to allow user to select choices for report/query. I
know how to write the SQL to modify the query based upon the user
choice using the afterupdate event. What I'm having problems with is
how to be able to offer the Default choice of "ALL" for the initial
form screen combo box with the bound field from the combo box being a
number field... I can get it to work if I bind the combo box query to
the text description field, but since I really want to bind to the
unique number for further query filtering, I'm curious if there's a
better way to do this...

See this page:

http://www.mvps.org/access/forms/frm0043.htm
Forms: Adding "All" to a listbox or combobox

 

[Guest]

looks like it will be just the ticket - I'll try it tonight (my database is
at home) & will keep you posted - thanks

 

[Guest]

worked like a charm - thanks so much!!

looks like it will be just the ticket - I'll try it tonight (my database is
at home) & will keep you posted - thanks