Text box shows ID field and not the Name

[jzacharias]

I have a subform with a text box that I want to show the driver name from the driver table but it only shows the ID field. The control source is Driver_ID and I am using the Default Value =[Forms]![Squad]![Driver]. It functions how I want except for showing the name. I think I understand that the reason for it showing is the Control Source, but I don't have another option to choose besides the Driver_ID in the drop down.

[RayMilhon]

Use a second Textbox with the name set the visible property of the existing textbox to no.

[jzacharias]

unless my relationship is set wrong, I don't have the option to use any fields from the driver table

[RayMilhon]

In that case use a listbox instead of a text box. The Row Source would be:

Select Drivername from drivertable where driverid = [Forms]![Squad]![Driver]

[RayMilhon]

oops forgot the control source would be left blank

[jzacharias]

I will try that