> Ok. Got it.  Actually Filter by itself (if it is exposed as a Property) will
> allow the navigation on the Recordset that is established by the original
> Where
> Clause without the Closing and Reopening of the Form.

I don't think that Filter would do it by itself.  Imagine the case in which
there are 120 Smiths, and you want to start on John, but have access to the
rest.  You do:

EDIT USING Form WHERE LastName = 'Smith'

and in the On After Start EEP, filter for FirstName = 'John'.  You have the
record you want.  But what should "Previous" do?  Should it move to the
preceeding record, Ira?  That record isn't in the filter.

What you really want to do is Find the first 'John' in the record set while
keeping all other Smiths available.

Also, there's a (small) problem in that the current syntax is like this"

PROPERTY TABLE TableName METHOD

since the PROPERTY command for tables is currently used only to run
parameterless methods of the underlying dataset.  You need a further argument 

PROPERTY TABLE TableName FILTER 'FILTER_CONDITION'

or

PROPERTY TABLE TableName FIND 'FIND_CONDITION'

--
Larry

Reply via email to