I have several txtBoxes that I want to edit the Control Sources of each of
them. If I set a variable to the name of the txtBox, can I somehow
dynamically call the control source of the txtBox by a variable as suppose to
writing out the code for each one in long form? Confused? Here's my code

Option Explicit
Dim SomeFormula

Me.txtBox.controlsource = "=" & SomeForumula

Can I somehow do this:

Me. & Array(I) & .controlsource= "=" & SomeFormula

Is this possible? Still Confused? (So am I sometimes...)

I also want to know if it's possible to set a variable to equal a control
source based on a variable?

dim x

x=Me. & var1 & .ControlSource.Text

Can this be done without actually typing the txtboxes name as to using a
variable in its place? Thanks.

Kou

In news:3C91E467-349D-47C1-99E8-(E-Mail Removed),
Kou Vang <(E-Mail Removed)> wrote:
> I have several txtBoxes that I want to edit the Control Sources of
> each of them. If I set a variable to the name of the txtBox, can I
> somehow dynamically call the control source of the txtBox by a
> variable as suppose to writing out the code for each one in long
> form? Confused? Here's my code
>
> Option Explicit
> Dim SomeFormula
>
> Me.txtBox.controlsource = "=" & SomeForumula
>
> Can I somehow do this:
>
> Me. & Array(I) & .controlsource= "=" & SomeFormula
>
> Is this possible? Still Confused? (So am I sometimes...)

You can use the name of the control as a string index into the Controls
collection; like this:

Me.Controls(Array(I)).Controlsource = "=" & SomeFormula

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

In news:511C16B7-68BD-4658-AE52-(E-Mail Removed),
Kou Vang <(E-Mail Removed)> wrote:
> I also want to know if it's possible to set a variable to equal a
> control source based on a variable?
>
> dim x
>
> x=Me. & var1 & .ControlSource.Text
>
> Can this be done without actually typing the txtboxes name as to
> using a variable in its place? Thanks.

Use:

x = Me.Controls(var1).ControlSource

There is no ".Text" property of the ControlSource, which is itself a
text property.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

I forgot to mention that I am trying to edit txtBoxes that are in a report
through a form I am running. Can I open a report while running the code from
the form, and edit the txtboxes of the report through the forms code?

Kou

"Dirk Goldgar" wrote:

> In news:3C91E467-349D-47C1-99E8-(E-Mail Removed),
> Kou Vang <(E-Mail Removed)> wrote:
> > I have several txtBoxes that I want to edit the Control Sources of
> > each of them. If I set a variable to the name of the txtBox, can I
> > somehow dynamically call the control source of the txtBox by a
> > variable as suppose to writing out the code for each one in long
> > form? Confused? Here's my code
> >
> > Option Explicit
> > Dim SomeFormula
> >
> > Me.txtBox.controlsource = "=" & SomeForumula
> >
> > Can I somehow do this:
> >
> > Me. & Array(I) & .controlsource= "=" & SomeFormula
> >
> > Is this possible? Still Confused? (So am I sometimes...)
>
> You can use the name of the control as a string index into the Controls
> collection; like this:
>
> Me.Controls(Array(I)).Controlsource = "=" & SomeFormula
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>
>

In news:8436056A-E8AE-4208-ACA3-(E-Mail Removed),
Kou Vang <(E-Mail Removed)> wrote:
> I forgot to mention that I am trying to edit txtBoxes that are in a
> report through a form I am running. Can I open a report while
> running the code from the form, and edit the txtboxes of the report
> through the forms code?

I think you'd better put the code to modify controlsources in the Open
event of the report. Even if Access will let you do it after the
report's Open event has finished -- and it may not -- I'm not sure if
there's any other way for you to ensure that the text boxes'
controlsources are set before the report actually starts to print them.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)