I have a report that shows phone calls for a selected Contact for a select period.
I have a Date Range Form on which I put an unbound ComboBox to select a Contact for a report. The row source for the ComboBox:
SELECT Contacts.ContactID, qryContactNameV1.ContactName
FROM Contacts INNER JOIN qryContactNameV1 ON Contacts.ContactID = qryContactNameV1.ContactID;
I have Col count =2, and widths = 0.5";2"
I have a query for the report:
SELECT qryContactNameV1.ContactID, qryContactNameV1.ContactName, Calls.CallDate, Calls.CallTime, Calls.Subject, Calls.Notes
FROM Calls INNER JOIN qryContactNameV1 ON Calls.ContactID = qryContactNameV1.ContactID
l]) AND ((Calls.CallDate)>=[forms]![frmReportDateRangeForCallsV1]![Start Date] And (Calls.CallDate)<=[forms]![frmReportDateRangeForCallsV1]![End Date]))
ORDER BY qryContactNameV1.ContactName;
I When I click the ComboBox for drop down list, it shows both ContactID and ContactName. But when I select, only the ID posts in the field. I need the ID for ease of navigating to the correct Contact out of several thousand; however if only the ID posts it may be disconcerting to the user.
How can I get the ID and Name to post?