Setting a value for a field

[Hervor]

I'm pretty new to access so this may be blindingly obvious to the rest of you

I have two tables relating to People

PeopleType: ID and description (e.g. 1 student, 2 teacher, etc)
PeopleDetails: PeopleType.id, name, gender etc

I have a form that contains subforms
On the Main section of the form the data comes from the PeopleDetails. I want the user to fill in this but I want the PeopleType.id to be set to e.g. 2 so that you can only key in teacher details.

Does this make sense? I've been stuck on this for days now and cannot get it to work. I have been trying to set it using a macro SetValue but i cannot get it to work.

Any advice would be really appreciated.

 

[ypma]

No sure i understand the requirement 100%
Would setting the lock to yes via the Properties of the ' people.id field tab data then Locked to yes .This would prevent anyone typing into that field .

 

[zooropa67]

Are you entering people details into the subform or into the main form? Why don't you want to enter student details there?