I have a contact management database that I want to auto complete the salutation field based on the salutation + First Name + MI + Last Name + suffex. It is for ease of use and creating labels. I have to have a seporate salutation filed because it is not always going to be those fields some people require different salutations. How do I go about creating this. Do I do it in the form or the table?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trying to auto fill in field based on multiple fields
- Thread starter gouldish
- Start date
straybullet
IS-IT--Management
Perhaps something along the lines of the following in your source query (you could also set it as the control source of a textbox on your label report with a leading '='):
Trim([Salutation] & " " & [FirstName] & " " & [MI] & " " & [LastName] & " " & [Suffix]) &" ,"
Let them hate - so long as they fear... Lucius Accius
Trim([Salutation] & " " & [FirstName] & " " & [MI] & " " & [LastName] & " " & [Suffix]) &" ,"
Let them hate - so long as they fear... Lucius Accius
- Status
Similar threads
