How Can i display a record from my datagrid on my form

[Nelson]

Hi Folks,

How can I display a record i double clicked on my datagrid on another underlying
form.

Thanks all your anticipated help.

[Jim]

"Nelson" <jbamisaye@yahoo.com> wrote:
>
>Hi Folks,
>
>How can I display a record i double clicked on my datagrid on another underlying
>form.
>
>Thanks all your anticipated help.
>
>
'*******************************************
If your database is opened on the form load then this would work:

rstStud1.Open "SELECT field1, field2, field3 FROM Database
WHERE Field = '" & txtSong.Text & "'", conn, adOpenStatic, adLockOptimistic

Set DataGrid1.DataSource = rstStud1

All you have to do is select the fields on the form to fill in from the database
and this should work. If your database is not opened on the form load then
you'll have to connect to it before you run this. Let us know if you still
have problems.

Jim