I trying to create a script that will automatically find only the records from my status field "active" and omit the rest upon opening.

I already know how to set a script to run when opening, but I can't seem to figure out how the script should read.

RET

Try this:

Go to Layout [x]

Set Error Capture [on]

Enter Find Mode

Set Field ["StatusField","active"]

Perform Find

If Status(CurrentError="401")

Show Message["No active records in the database!"]

etc.

End If

Tom

[email protected]

http://www.tgparker.com/filemaker