ACCESS - Report Generation from Query
Im generating a report on all assets in a room.
I select the building from a combo box, this propagates the next combo box with the rooms relevant to the building.
I then pass the room selection to the query -
Now my issue is that "cboProducts_2" displays the descriptive name for the room and not the RoomID needed to generate the results. How can I still select the descriptive name from the combo box but pass the RoomID to the query?
SELECT Assets.AssetID, Assets.AssetDescription, Assets.AssetCategory, Assets.StatusID, Assets.BuildingID, Assets.Building, Assets.Room, Assets.Make, Assets.Model, Assets.ModelNumber, Assets.SerialNumber, Assets.RoomID
WHERE (((Assets.RoomID)=[Forms]![Audit Tools]![RoomAudit].[Form]![cboProducts_2]))
ORDER BY Assets.RoomID;
I'm positive I have done this before, but for the life of me cant remember (damn you xmas holiday)