Where is the best place to do a form.requery

[Pack10]

I am looking for the best way to do a requery on a form or forms.

I have a save routine where the user will change the status of the record. I have 2 forms
that act as datasheets or grids (that are filtered on status they are split forms) where they select the appropriate record. Now, when the status changes in the save routine, is it best to do a form.requery there after the .update ..... or in the form.activate property of the split form?

 

[TheAceMan1]

How are ya Pack10 . . .

Hmmmm ... mmmm ... in your mind what does a requery do?

 

[Pack10]

A request will refresh the record set
That the form is based on. But, of
The user keeps the form open I need
It to reflect the records. Of the form
If the form is filtered on a particular
Status then I don't want that
Record showing up on the split
Form.

 

[TheAceMan1]

Pack10 . . .

I've never had the need to use a split form, however both views of the form are based on the same datasource so I don't see how you can filter one view and not the other ...

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]