Datagrid questions

[whotookpol]

Hi,
I have a ComboBox that is populated with data, when the user selects something I need it to populate a datagrid, and then be able click an item in the datagrid and it loads data into a form template, so I don’t have to have a different form for each data....Im using ADO.

If that makes sense!

[vbcodec]

your question is very unclear, let us know what field is in combo and what fields you want to display on datagrid, are you binding data to combobox? or you just provide data for combo manually?

and what do you mean LOAD DATA into a form TEMPLATE?

[whotookpol]

Sorry im beginning database work and im confused aswell!

Ok don’t worry about the ComboBox bit..

what fields you want to display on datagrid

i need field 'forename' and 'surname' from tbl_names

and what do you mean LOAD DATA into a form TEMPLATE?

Need to be able to click a name in the datagrid, then it loads info about them into a form. But instead of having a form for each person I somehow need one form for many people.

I would like to be able to load all the fields from a record into separate labels on the form.

Hope that’s clearer, thanks!

[vbcodec]

well if you load whatever you need with sql command and bind all labels and grids to you ADO Recordset it will work fine for you.

you should load your sql command something like this:

Select tbl_names.forename, tbl_names.Surnames, secondTable.firstField, secondTable.ForthFild FROM tbl_names, secondTable WHERE tbl_names.ID = secondTable.ID


hope it helps.
S. Mohammad Najafi

PS : Don't forget to BIND it all of them to your ADODB Recordset