Hi Folks

Need some advice. I am trying to use the DataGrid Click action of a DataGrid control to open up a form and populate textboxes with the details from the specific record that is selected on the DataGrid. The datasource is from an Access 2000 db using an adodc control for connection.
Can anyone help

As 17 people have viewed this but not replied, can I take it that this cannot be done or have I not supplied enough info. All help greatfully appreciated

because the information is already displayed in the grid, why do you want to show it in another form using text boxes?
Marco

Thanks Macrostraf.
The reason I need this funcitonality is that I have a data entry page that I wish to populate with data from various datagrids. ie at txtname I would like the user to type in a name and then click a command button to open a form with a datagrid that shows a list of all users with that name. It will also should other info such as location address telephone no etc. When the user clicks on the correct record from the grid, I would like the information from that record to appear on the original data entry form. It can be done in MS Access but I am not sure how to do this in VB6.

in what part do you need help?

I am giving you some ideas here.

Let's suppose that you have a textBox called txtName and a button called btnName.
Add a new form to your project, called it whatever you want like frmDisplay. In the btnName click event show the frmDisplay form, and pass to it the right query like

"select * from mytable where Name = '" & txtname.text & "'"

and bind the grid to this query

Marco

Thanks Macrostraf, that has helped.
It is not the solution I was looking for but it has given me a lot of pointers. If I need more help I will post again
Cheers

Here is some help. you need to OleDB to connect to the ms access database. You need to create a dynamic sql statement that will create the sql and write it to the ms Access database. Then attach the grid to the sql statement from the access database.

ICQ me if you need help.

Thank you

rbgamer