Access (Yes again) - Report Prompting for missing fields
I have a button to generate a report based on a selection in a combo box.
This is working but it keeps prompting for a field not in the report or query.
The selection is for an assettype (PC, Printer, etc) and I run the report using its text value, however it also asks for the assettypeID when the report preview is clicked.
As stated before the assettype value is passed successfully and the report is generated as expected.
I realise I may have issues not generating the report by a primary key so I swapped them over and its stopped passing the parameter to the query! I hate access :(