Chrstine Pearce
Registered User.
- Local time
- Today, 23:11
- Joined
- Oct 20, 2003
- Messages
- 12
Hi there. I'm a frustrated FoxPro coder tried to come to grips with Access -- I don't understand it at all! Please help!
In a form called frmCreateCAR, a user wants to automatically complete contact details:
Name
Phone
Email
Mobile
Do do this, the user clicks a buton named EmployeeBtn which successfully opens a form called frmEmployees.
frmEmployees lists the fields from the employees table:
LastName
FirstName
Phone
Email
Mobile
Here's where I'm having big problems and this is what I want to happen: When the user finds the name they want, they double-click the LastName field. The fields are stored to memory (which have been declared as public in frmCreateCAR):
mName =LTrim$([LastName])+", "+LTrim$([FirstName])
Phone, Email and Mobile are also stored as mPhone,
mEmail. etc.
The Employees form then closes automatically and returns to the frmCreateCAR form where the fields Name, Phone, Email and Mobile are duly updated with the memory variables.
It sounds like this should be SO easy, but I can't for the life of me figure out how to do it. Any help will be greatly appreciated.
Cheers, Christine
In a form called frmCreateCAR, a user wants to automatically complete contact details:
Name
Phone
Mobile
Do do this, the user clicks a buton named EmployeeBtn which successfully opens a form called frmEmployees.
frmEmployees lists the fields from the employees table:
LastName
FirstName
Phone
Mobile
Here's where I'm having big problems and this is what I want to happen: When the user finds the name they want, they double-click the LastName field. The fields are stored to memory (which have been declared as public in frmCreateCAR):
mName =LTrim$([LastName])+", "+LTrim$([FirstName])
Phone, Email and Mobile are also stored as mPhone,
mEmail. etc.
The Employees form then closes automatically and returns to the frmCreateCAR form where the fields Name, Phone, Email and Mobile are duly updated with the memory variables.
It sounds like this should be SO easy, but I can't for the life of me figure out how to do it. Any help will be greatly appreciated.
Cheers, Christine