AccountName find script

[Reid]

I have my database set up so that the user logged in can only see their records which they created. The problem is that when they open the layout to see their records it shows a bunch of records. Is there a way I can add a script to the button that navigates to this layout view that automatically does a find and only shows records created by them instead of showing all records?

[Fitch]

If you've set security privileges for this, when you do a normal Find, the user will only see their own records. Perhaps you already know that. The problem is with the Show All Records command, and also when the database opens and all records are present.

If you already have a script that navigates to the layout, just add a Find * (wildcard) in the primary key field, or you could use greater than 0 if it's a number field. The security privileges will handle the filtering.

[Reid]

Thank you!

Worked like a charm. You are my hero!