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.

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.