Limiting records - is this possible?

[Jagged]

Hi


We have a database with one main data entry which stores records in a seperate table. There are several thousand records keyed in using this form. Therefore, alongside the entry we have a search form which allow the user to search for a specific record and display it in the main if he/she needs to edit one.

We have received a request from users for a functionality which allows users to browse all records, using the main form layout, that they have keyed in. I guess what I am asking is: Is there a way to limit the records visible in a form using field on that same form as a limitation (ie. the users name - which is a required key-in)?

Any ideas?

 

[missinglinq]

Sure, you just Filter the Form on the 'name' Field. The user can do that through the ribbon (Home Tab - Filter) or you could write code for a custom Command Button, depending on the Form's view, that Filters it.

If the name is available before the Form is Loaded, you could use code in the OnLoad event to do it.

Linq ;0)>

 

[CJ_London]

Or just right click on the field and select the filter option (not available in runtime unless shortcut menu provided)