help desperately needed!!

[mmm455]

hi,i am creating a database for a driving school.

i have an update records page which is set out like this..

Pupil id
Forename
Surname
Address 1
Address 2
Postcode
Date of birth
Driving history

I have the data to this stored in a table but i want it so that when i enter the pupil name, the rest of their details like address, postcode and date of birth etc automatically come up for that pupil once their name as been entered.

how do i get this to work??

Also... i have an invoice page as follows...

Invoice id
Name
Number of lessons
Type of lessons
Total cost

I want it so that for the name field, instead of having two separate fields, forename and surname, i want it so that both the surname and forename appear in the name field together. how do i do this..is it a calculation??


Help will be very very very much appreciated

 

[DCrake]

Q1
Of you use a combo box to get the pupil you can use more than one column but hide the columns using the column widths property, to hide the fileds you don't want/need the user to see.

Then after the user has picked a pupil you can tell it that the surname field is comboBox.Column(x)

However alot depends if you are using a bound or unbound form.

Q2
To join two fields together use

FullName = Forename & " " & Surname

 

[mmm455]

using an unbound text box