Access - VB to copy info from a Main Form Textbox it's SubForm Textbox using Variable Name

wlwebb
wlwebb used Ask the Experts™
on
Hello All

Have a form with several Subforms.  I have been using variables to cycle through copying info within forms but this one is a variable that copies info from one form to several  subforms.  

I know I can use Me("xxxx" & i) = Me("xxx" & i+1) within a form but can you do that from a Form to a Subform?

I have tried this and it does not like my Syntax.    I get Run-Time Error '2465' Can't fine the field '|' referred to in your expression???????


My code is
                ["sfrm_ctl_Addr" & x].Form![txtStreetName] = Me("txtStreet" & (Format(x, "00")))
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
mbizupNerd
Most Valuable Expert 2012
Top Expert 2013

Commented:
Have you tried this?


Me.SubformControlName.Form("xxxx" & i) = Me("xxx" & i+1)
Nerd
Most Valuable Expert 2012
Top Expert 2013
Commented:
Maybe this...

                Me.Controls("sfrm_ctl_Addr" & x).Form![txtStreetName] = Me("txtStreet" & (Format(x, "00")))

Open in new window

wlwebb

Author

Commented:
Hmmmm... no!  Give me a minute.........
wlwebb

Author

Commented:
PERRRRFFFEEEECCCTTTTT!!!!!!!!  Thanks Mbiz!!!!!!!!!  I Really appreciate it.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial