[AccessD] List Box Selection on a Report

Kaup, Chester Chester_Kaup at kindermorgan.com
Mon May 21 13:55:30 CDT 2007


Unfortunately it does not work. Just returns #ERROR.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Monday, May 21, 2007 1:06 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] List Box Selection on a Report

Should work perfectly fine then. You're not by any chance closing the
form
before opening the report are you?

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Kaup, Chester
> Sent: 21 May 2007 16:59
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] List Box Selection on a Report
> 
> 
> I typed it wrong. Should be =[Forms]![Form1]![ManifoldList]
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
> Sent: Monday, May 21, 2007 10:53 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] List Box Selection on a Report
> 
> Chester, unless you just typed it wrong you missed the [ off 
> the front of Forms
> --
> Andy Lacey
> http://www.minstersystems.co.uk
> 
> 
> 
> --------- Original Message --------
> From: "Access Developers discussion and problem solving" 
> <accessd at databaseadvisors.com>
> To: "Access Developers discussion and problem solving" 
> <accessd at databaseadvisors.com>
> Subject: [AccessD] List Box Selection on a Report
> Date: 21/05/07 15:26
> 
> 
> I have form with a list box on it. When the user clicks on a 
> selection, an on click event runs that opens a report based 
> on the selection. This works fine. Now I need to display the 
> list box selection in a text box on the report. I set the 
> text box control source to =Forms]![Form1]![ManifoldList]. 
> This just returns Name? What might I be doing wrong?
> 
> 
> 
> Chester Kaup
> 
> Engineering Technician
> 
> Kinder Morgan CO2 Company, LLP
> 
> Office (432) 688-3797
> 
> FAX (432) 688-3799
> 
> 
> 
> 
> 
> No trees were killed in the sending of this message. However 
> a large number of electrons were terribly inconvenienced.
> 
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> ________________________________________________
> Message sent using UebiMiau 2.7.2
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list