Outlook Contact Form Full name

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

"Billiam" wrote in message
...
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

"Billiam" wrote in message
...
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