Gkirkup
03-12-2008, 06:47 PM
I have a report on which a number is displayed in a listbox. How do I copy that number to another control on the report? I expected Me!ControlName to work, but it does not.
Robert
Robert
|
View Full Version : Referring to a listbox result Gkirkup 03-12-2008, 06:47 PM I have a report on which a number is displayed in a listbox. How do I copy that number to another control on the report? I expected Me!ControlName to work, but it does not. Robert llkhoutx 03-12-2008, 07:50 PM List boxes are not appropriate for and should not the used on reports. Gkirkup 03-12-2008, 09:33 PM OK. I am using the listbox just to get the result of a query to the report. What should I use to display the query result on the report? Robert llkhoutx 03-13-2008, 06:08 PM Use the query as the recordsource of a report. Your can use ter report wizard to build the report; the wizard allows specification of the recordsource. Gkirkup 03-13-2008, 06:47 PM The report has a table as the recordsource. I wanted to print just one number from a query, so I thought a listbox might be the easy way to do that. I ended up using a subreport. Robert llkhoutx 03-13-2008, 07:37 PM use the Dlookup function for one field. |