J
Justin Mills
I am designing a order entry database.
What i would like to do/have, is a form with a label
boxes, ruffly named as follows; txtPhoneNumber,
txtFirstName, txtLastName, txtStreetNumber etc etc
When you enter a phone number into the txtPhoneNumber
box, on the lostfocus it query my customer table and
enters in the firstname, lastname etc etc record that
matches the phonenumber.
But if there is no customer on file with that
phonenumber, you can enter in there details in the empty
boxes and have say a command button to save the new
customer record.
Hope that makes sense.
Thanx in advance
Justin.
What i would like to do/have, is a form with a label
boxes, ruffly named as follows; txtPhoneNumber,
txtFirstName, txtLastName, txtStreetNumber etc etc
When you enter a phone number into the txtPhoneNumber
box, on the lostfocus it query my customer table and
enters in the firstname, lastname etc etc record that
matches the phonenumber.
But if there is no customer on file with that
phonenumber, you can enter in there details in the empty
boxes and have say a command button to save the new
customer record.
Hope that makes sense.
Thanx in advance
Justin.