Sep 16, 2009 #1 tadzo IS-IT--Management Joined Sep 16, 2009 Messages 1 Location US Using Access 2007, VBA within a Form – Is there a way to transform code such as: Me.text1=x(1) Me.text2=x(2) Me.text3=X(3) To something like: For I = 1 to 3 Me.text(I)=X(I) Next I Thanks!
Using Access 2007, VBA within a Form – Is there a way to transform code such as: Me.text1=x(1) Me.text2=x(2) Me.text3=X(3) To something like: For I = 1 to 3 Me.text(I)=X(I) Next I Thanks!
Sep 16, 2009 1 #2 MajP Technical User Joined Aug 27, 2005 Messages 9,382 Location US dim i as integer for i = 1 to 3 me.controls("text"&i) = x(i) next i Upvote 0 Downvote