Concatenate & forms

N

northstar

I have created a query containing the concatenation of customer ID, LName,
and FName. Syntax is not a problem. Can I use this concatenation as a look-up
in forms wherever the data is needed? Many of our forms have three data entry
fields for this same data. I want to consolidate the three into a single
look-up for multiple forms. Thanks for replies, even if you tell me I can't.
 
R

Ron2006

Yes it will work, but I am not sure why you would need to have the
three fields concatenated. A lookup or for that matter a combo box
with the ID as control or a linked table linked by ID would seem to be
sufficient unless you have multiple lastnames etc for a single
customer ID.

Ron
 

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

Similar Threads

Concatenate Question 6
OneNote and MS Forms 0
Copy previous record into form field 0
Concatenate multiple rows Into one Unique Identifier 1
Concatenating indexed list (returns index instead of data) 3
Union Query - Select Distinct 2 fields 7
concatenate problem 3
Multiple Parameter Crosstab query filter by form 1

Top