What you say Tat sounds like dependencies between forms. I would strongly recommend that you use private datasessions, to avoid those dependencies. That is, you should set the property Form.DataSession equal to "2 - Private".

In this case, tables opened in one form will not interact with tables in another form - it is almost as if each form is a separate user. In fact, you can run the same form more than once!

Please note that if you do this, some settings in the form will be changed to default, so you have to set them at the beginning of each form (preferably in Form.Load).

Some important settings which you may want to change include:

SET SAFETY OFF
SET TALK OFF
SET DELETED ON

These settings, and others, are scoped to the current datasession. That means that, for example, SET DELETED can be ON in one form, and OFF in another.

Greetings,

Hilmar.

>hi,
>thank you for reply,
>but still i get a meesage(filter cleard), when i move from, form to another form.
>when i run every form aloan like forms(add,modify,query or delete) it works.
>i put this code for all forms (add,modify,query or delete)
>when i run main menu(have all forms) i get error message (filter cleard)
>any help,
>this is the code.
>
>SELECT book1
>index on no tag no
>
>lcValue= ['] + UPPER(ALLTRIM(THISFORM.TEXT24.VALUE)) + [']
>SET FILTER TO UPPER(NO) = &lcValue.
>
>LOCATE
>IF EOF()
> MESSAGEBOX("NOT FOUND")
> *- Clear the filter.
> Set Filter To
>ELSE
> THISFORM.GRID4.REFRESH
>ENDIF
> endif*-------for if nkeycode=13