Sep 16, 2009 #1 tadzo IS-IT--Management Sep 16, 2009 1 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 Aug 27, 2005 9,382 US dim i as integer for i = 1 to 3 me.controls("text"&i) = x(i) next i Upvote 0 Downvote