combo Box with "All"

  • Thread starter Thread starter Guest
  • Start date Start date
G

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...
 
Pat K said:
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...
Click to expand...

See this page:

http://www.mvps.org/access/forms/frm0043.htm
Forms: Adding "All" to a listbox or combobox
 
looks like it will be just the ticket - I'll try it tonight (my database is
at home) & will keep you posted - thanks
 
worked like a charm - thanks so much!! :)

Pat K said:
looks like it will be just the ticket - I'll try it tonight (my database is
at home) & will keep you posted - thanks
Click to expand...
 
Back
Top