Please try this Quick Program..

[Lethal]

Please Try this quick program:

Example to work out:
2 text boxes:
1 adodc control:
1 data list:

Use the NWIND.mdb from VisualStudio folder
Set the first text box to the customer ID
Set the second text box to customer name
Set the list to the Customer ID

As I scroll through using the adodc control, all fields are continous changed. Yet say i click on a customer ID from the list, is there a way to get the fields to change like they were using the adodc control??? ehhh been stuck on this one..I'm probably just over looking something.

Thank you

[Danial]

Hi Lethal,
If you are using MS DBList then you can simply do

'set the RowSource of DBList1 to Data1
'set the ListField to "CustomerID"

Private Sub DBList1_Click()
    Data1.Recordset.Bookmark = DBList1.SelectedItem
End Sub

[Lethal]

Thank you, i'm getting closer now.
I just tried that, it's giving me an error saying object doesn't support this property or method.

[Danial]

Hi,
I have a feeling that you are using the wrong Control. Instead of using Microsoft Data Bound Grid you are using Microsoft Dta Grid. They look almost the same and share almost all the properties. I know this coz i made the same mistake !!

[Lethal]

I'm using the right control, i'm just wondering are you saying to use two data controls, one adodc and one dao??

thaknks

[Danial]

Hi,
Sorry i didnt read your question properly and didnt realise that you are actually using ADODC control, i assumed u r using Standard Data Control.

Try the following code, this one is using ADDOC control and i am also using Microsoft DataList Control.

Private Sub DataList1_Click()
    Adodc1.Recordset.Bookmark = DataList1.SelectedItem
End Sub

[Lethal]

Ya, if it's working for you it must be right. Mine still isn't working, i must have my fields linked wrong or something?? I'll keep working on it, thanks again