Changing fields relating to combobox

[Guest]

Hi,
Access novice here!

I have Form (plus subform) which contains 4 fields (Surname, Forename, Year,
Tutor Group). The "Surname" is a combobox with RowSource set to table
"Student List" which has Surname as primary key. I have set the Surname
Column Count to 4 and column widths to 1",0",0",0".

What do I need to code (VBA?) to change the Forename, Year and Tutor Group
fields when the combobox selection changes. I believe I can use the
AfterUpdate event where I want something like:.

Private Sub Surname_AfterUpdate()
me.forename="Student list".forename
etc
End Sub

TIA.

 

[Guest]

Hi,
I have read another recent posting and discovered I can achieve this
using the Controls Wizard!

Thanks to anyone who has replied meanwhile.