Merge 3 values into one field?

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

I have linked two databases together with the
same "Personal details table". So when the user inputs a
Customer name it supplies a drop down box to choose from,
but this makes the user have to input Customer ID, Name
and Surname separately. I got around this in a Form by
putting in a subform and linking the subform fields with
the main form fields by using the Expression builder.
However this doesn't put the value into the fields in the
Query or Table. I need this value in the query because I
plan to make a Tabular Form to search from but its not
possible to put a subform in without it changing the form
type. I think I am making this harder than it needs to
be. Is their any way to merge 3 values into one field?
ID, Name and surname all go into a new field called
Customer?

Many Thanks
Adam
 
Is their any way to merge 3 values into one field?
ID, Name and surname all go into a new field called
Customer?
Click to expand...

Sure. In a Query just type

Customer: [ID] & ": " & [Name] & " " & [Surname]

to display (e.g.) 364: John Vinson. You can use this Query as the
rowsource for your combo.
 
Back
Top