Need help! Automated data entry in forms

[fionac27]

hi guys,
for my project I'm doing a database for a college. I've it all done but my lecture asked to do automated data entry in forms. So if a user opens a form they will be able to add a record and say if they type in a students name the subject will appear when they press enter. I'm a bit confused on how to do this as it is not run on query. So any assistance would be grateful thanks in advance!

 

[Beetle]

You could use a combo with a row source that returns all the fields you need, plus some unbound text boxes that reference the extra columns in the combo box.

=YourCombo.Column(x)

Where x is the index of the associated column. The index is zero based.