Changing fields relating to combobox


G

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.
 
Ad

Advertisements

G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top