Also you can -- if you set your text boxes up as an Array of textboxes -- could use a For Loop
n = number fields in a record
For i=1 to n
text(i).text = datagrid1.coloumn(i).value
Next i
But in either case its best to call a function to do it since I imagine you might be filling those textboxes over and over again and its always better to have the code external to an event (click) in most cases keeping the code for an event very very simplistic and helping keep your code much more portable
--- On Sun, 9/26/10, vry_conan@yahoo.com <vry_conan@yahoo.com> wrote:
> From: vry_conan@yahoo.com <vry_conan@yahoo.com>
> Subject: Re: [Access VBA Central] visual basic 6
> To: AccessVBACentral@yahoogroups.com
> Date: Sunday, September 26, 2010, 6:44 PM
> Maybe like this : text1.text =
> datagrid1.coloumn(O).value
> text2.text = datagrid1.coloumn(1).value
> Sent from my BlackBerry® smartphone from Sinyal Bagus XL,
> Nyambung Teruuusss...!
>
> -----Original Message-----
> From: "sawaaj" <sawaaj@yahoo.com>
> Sender: AccessVBACentral@yahoogroups.com
> Date: Sun, 26 Sep 2010 19:29:04
> To: <AccessVBACentral@yahoogroups.com>
> Reply-To: AccessVBACentral@yahoogroups.com
> Subject: [Access VBA Central] visual basic 6
>
> Hi all
> i want to know on how can i simply display the data in
> datagrid in the textbox.for example the user will click on
> one item in the datagrid and then all the data from the row
> will be displayed in each of the textbox that i've assign
> for each of the fields in the recordset.help me.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
> AccessVBACentral-fullfeatured@yahoogroups.com
>
>
>
Nenhum comentário:
Postar um comentário