Outlook Contact Form Full name

B

Billiam

I am trying to create a form like the outlook 2007 Contact Manager Form.
The Outlook Contact form itself...should it be bound or unbound and why. I
started by having it unbound and using the Full Name command button to open
the Full name details form which is bound to the People table....but how do I
get the concatenated full name with salutation and suffix to appear in the
text box beside the fullname command button, and autofill the business card
with the concatenated name?
I assumed I could simply base the textbox on a concatenation of the info
that was entered in the bound pop up Full name details form, but because I
store the ID's of Salutation and suffix, I end up with numbers at the
beginning and end.

My People Table:
PeopleID PK autonumber
FName text
MName text
LName text
PrefFName text
SalutID
SuffixID

Any help on how to do this would be a great learning experience, and would
help me setup my contact form.

Thanks so much for any help!
Billiam
 

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