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.

--
JP Cummings

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/...UBED1=ACCESS-L

"Cummings" <(E-Mail Removed)> wrote in message
news:8CCCC2EE-629B-482D-8998-(E-Mail Removed)...
> 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.
>
> --
> JP Cummings

On Wed, 9 Jan 2008 06:44:05 -0800, Cummings wrote:

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


--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Fred --

You're a genius.

Thanks.

Jim
----
JP Cummings


"fredg" wrote:

> On Wed, 9 Jan 2008 06:44:05 -0800, Cummings wrote:
>
> > 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.
>
>
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>