filter a query by a selection in an active form

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

Guest

I need to use an entry in a field of a form to automatically filter hidden
queries so that the proper information will be displayed on the form and in
the form's dropboxes. For example, the user selects a product code and a
dropbox for the width is filtered to the list of widths for that product. The
database is in an Access 2000 file format.
 
I need to use an entry in a field of a form to automatically filter hidden
queries so that the proper information will be displayed on the form and in
the form's dropboxes. For example, the user selects a product code and a
dropbox for the width is filtered to the list of widths for that product. The
database is in an Access 2000 file format.
Click to expand...

You can use a criterion in your query of

=[Forms]![NameOfForm]![NameOfControl]

using (of course) your own form and control names.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top