Pulling full name into header of report in MS Access
Posted on 2013-01-10
I have a report that I want to do a summary at the top of the report and I am referencing form from its being executed from, but when it brings up the report I'm only getting the ID of the person instead of the full name
The dropdown in the form has two columns; [ID] and [Full_Name]. I hides the ID column and displays the Full_Name.
Property Sheet of Form:
Control Source = None
Row Source = SELECT [Printer_Names].[Printer_ID], [Printer_Names].[Full_Name] FROM Printer_Names ORDER BY [Full_Name];
Row Source Type = Table/Query
Bound Column = 1
Column Count = 2
Column Widths = 0"; 1"
="Printer From: " & [Forms]![frmIndPrint]![Printer_Name] & " To: " & [Forms]![frmIndPrint]![To_Printer_Name]
Printer From: 6 To: 6
How can I get this to display the Printer "Full_Name" instead of the "ID"?