How do I use the Form Properties to filter data?

  • Thread starter Thread starter Cummings
  • Start date Start date
C

Cummings

When checking the Properties of a form in Design View, I noticed a "Filter"
field.

I have been trying to get it to work for 3 days now.

I know it has to be a simple thing, but I'm at a loss. My attempts at SQL
expressions don't blow things up, but they don't work, either.

Basically, I have a field called "Spiral" with values "A", "B", "C", etc.
When I open the form, I just want to see the items associated with one (and
only one) of them.

I'd like for this to be invisible to the users.

Thanks.
 
When checking the Properties of a form in Design View, I noticed a "Filter"
field.

I have been trying to get it to work for 3 days now.

I know it has to be a simple thing, but I'm at a loss. My attempts at SQL
expressions don't blow things up, but they don't work, either.

Basically, I have a field called "Spiral" with values "A", "B", "C", etc.
When I open the form, I just want to see the items associated with one (and
only one) of them.

I'd like for this to be invisible to the users.

Thanks.
Click to expand...

One way, if you wish to do this using the form's Filter property, is
to code the Form's Load event:

Me.Filter = "Spiral = 'A'"
Me.FilterOn = True

The form will open filtered.

You could then toggle the filter on or off by right-clicking on the
form and selecting Remove Filter/Sort or Apply filter/Sort.
 
Back
Top