[AccessD] List Box Selection on a Report

Kaup, Chester Chester_Kaup at kindermorgan.com
Mon May 21 12:50:38 CDT 2007


Tried it that way. Works fine. Thanks.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Reuben
Cummings
Sent: Monday, May 21, 2007 11:26 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] List Box Selection on a Report

I typically set text boxes like this in the On_Format event of the
section
where the text box sits.

Header On_Format
	me.TextBox = [Forms]![Form1]![ManifoldList]
End Sub

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Kaup,
Chester
> Sent: Monday, May 21, 2007 11:59 AM
> 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