ID field numbers in Reports - Microsoft Access Forum


	Back to Access Forum Comments List

ID field numbers in Reports

William Farrar

5 years ago

I have downloaded all of the free templates from your website and found them very helpful. Although, only the Event Management template has a invoice report. My question is after implementing the cascading combo boxes (storing the ID of the record into the table), I tried creating a report using that table. The output in the report shows the ID number from the combo box selection, not the actual value that was chosen during the data entry. How do I switch the selection back for reports?

	Adam Schwanz @Reply 5 years ago
The value displayed is the bound columns value. You could change the bound column, but that could cause other issues. I would just make a new expression in a query called IDFix and DLOOKUP the actual value then display that field.

	Adam Schwanz @Reply 5 years ago
IDFix: DLOOKUP("ActualValue","TableName","ID="& ID)

	Adam Schwanz @Reply 5 years ago
DLookup if you need it

	Alex Hedley @Reply 5 years ago
Create a Query, join the tables you need by the ID, then use that as your RecordSource for the Report

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen