Filter by dialog

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: debraj007 <debraj007@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 5 Apr 2005 12:41:06 -0700

I've looked in the posts and didn't find exactly what I was looking for, hope
you can help :-). I have a form called quote. When you pull up that form I
would like the user to get a pop up dialog box with several of the fields
from my form that will allow them to filter. When they enter the information
(name, subdivision, county, quote number), or leave the fields blank, and
click a command button, I would like my quote form to come up with a filter
applied to show only the info they requested. Can someone tell me how to do
this?
.

Follow-Ups:
- RE: Filter by dialog
  - From: Sprinks

Prev by Date: Re: Maximum Field Limits on Reports and Forms?
Next by Date: Re: Records jumping in forms
Previous by thread: you can only run one instance of the combo box wizard at a time
Next by thread: RE: Filter by dialog
Index(es):
- Date
- Thread

Relevant Pages

Re: Run Time Errors
... changed the triple quote in the ... Private Sub cmdFilter_Click ... Build up the criteria string form the non-blank search ... apply the string as the form's Filter. ...
(microsoft.public.access.formscoding)
Re: Why John Ringo Threatens Science Fictions Future
... >>> You know I need to see if I can filter outomatically any of your posts ... >>> on Usenet without filtering them on the Bar. ... On Usenet you quote. ...
(rec.arts.sf.written)
Re: how can i filter my database?
... Do you have the subform synchronized with LinkMasterFields and LinkChildFields? ... Access Basics ... I have set them up with a "go" command button to filter the info in the table based on what I select in the combo box, and it shows up in a subform. ... sorry I put an extra quote mark in... ...
(microsoft.public.access.modulesdaovba)
Re: how can i filter my database?
... it shows up in a subform. ... stops working unless I right click the subform select "filter ... sorry I put an extra quote mark in (was distracted doing something ... Whenever you change code or references, your should always compile ...
(microsoft.public.access.modulesdaovba)
Re: News Group Reader ?
... posts, even though he's filtered. ... Would someone please explain to nearly everybody that just because you see a post or quote, it doesn't mean you have to read it? ... Most people use the same filter Will uses because they really DON'T want to miss anything. ... Hunter is no different, beyond the fact that most here wouldn't think of reacting to it the same way when Hunter does it as they do when Will does it. ...
(rec.outdoors.rv-travel)