How do I use the Form Properties to filter data?

[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.

 

[Roger Carlson]

Actually, I rarely use the filter property of the form for this. I prefer
to base the form on a query that is filtered the way I want. This can
either be hard coded or done programmatically, depending on what you want to
accomplish.
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[fredg]

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.

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.

 

[Cummings]

Fred --

You're a genius.

Thanks.

Jim