Text box to show multiple fields

[Rich1234]

Hi

I have a one to many relationship with two tables, Drivers and Vehicles,
which are both joined to a junction table. Within the drivers table, there
are the following fields: First Name, Middle Name(s), Surname and DOB. My
question for you is:

I have a form based on the Vehicles table, and within this is a subform to
display the drivers associated with each vehicle (based on the junction
table.) How can I display the Drivers first name, middle name and surname
together is one control on the subform rather than having to put each field
in a separate textbox? I know it's possible to concatenate fields using
combo boxes (there is an example on the Northwind Employees Form, in the
"reports to" combo box.) But is it possible to do this in a text box? The
problem is there is no row source property to specify the multiple fields. I
do not need to be able to select a new driver's name on the form so a text
box or similar would be better. I'm not a programmer so if anything complex
is needed I would be grateful if you could walk me through it.

Thanks in advance for your expertise

Rich

 

[Rich1234]

Hi again

I've sorted it... of course, just type
=[First Name] & " " & [Surname]
in the control source box.

I'm a relative newbie.... but learning bit by bit!

Thanks anyway

Rich