restricted search facility

[props]

Hello

i ve got a table of students (id , name , tel , address )

A search button required on a form with a text box (to enter data) , so the student types in his id number and retrieves his record ,ONLY .
So far i have created the form the search button which works fine . But the problem is the 'restriction' . How can i let the form know that only the student 111 can access his record?

 

[john471]

Not an easy proposition

How do you know who the student is that is sitting at the terminal ?

Have you secured the database properly, and created MS Access Logon Accounts for each user?

Even if you have done that, Access doesn't (automatically) provide record-level security, only object (table - for your puropse) level security; but there would be ways to achieve this, although they would require some serious coding.

Good Luck.

Regards

John.

 

[SunWuKung]

You should filter the recordset of the form for the UserID when loading the form (eg. with a parameter query).

As John sais when you load this form you should already know who the user is. If you don't know who the user is create a login form where he can specify his username and password, if there is a match store the UserID.

You should only use a user specified search string if a user can manipulate multiple records but wants to select which one to display now.

hth
SWK