Office Software Thread, Access (Yes again) - Report Prompting for missing fields in Technical; I have a button to generate a report based on a selection in a combo box.
This is working but ...
12th July 2012, 03:24 PM #1
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
Last edited by CHR1S; 12th July 2012 at 04:06 PM.
IDG Tech News
By danIT in forum General Chat
Last Post: 18th June 2008, 08:02 PM
By adamf in forum Windows
Last Post: 30th October 2007, 06:05 PM
By alan-d in forum How do you do....it?
Last Post: 28th March 2007, 11:32 AM
Last Post: 14th September 2006, 03:45 PM
By Mango_RW in forum Windows
Last Post: 6th October 2005, 01:49 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)