Restricting field entry (1 Viewer)

Ibnul Ahsan Mayukh

New member
Local time
Today, 17:59
Joined
Feb 24, 2014
Messages
7
In a table I have 3columns with the primary key of MemberID. Of the columns in question, one is StudentID and the other is StaffID. What i want to do is that if a use enters the information in MemberID, he will not be able to input in the field in StaffID and vice versa. Can this be done? If so, how?
Thanks in advance.
 

jdraw

Super Moderator
Staff member
Local time
Today, 06:59
Joined
Jan 23, 2006
Messages
15,361
Don't let users interact directly with tables. Always use forms. Use some vba to validate user data entry according to the rules you set up.
 

R. Hicks

AWF VIP
Local time
Today, 05:59
Joined
Dec 23, 1999
Messages
619
You can easily control this at Form level .. but not at Table level.

R.
 

Ibnul Ahsan Mayukh

New member
Local time
Today, 17:59
Joined
Feb 24, 2014
Messages
7
Well, how do i that on a form level. any help at all is appreciated as i am a complete novice.
 

Users who are viewing this thread

Top Bottom