I'm new to using the adodc ADO control and need a little help here.
I have a form "frmDB" with an Adodc1 control set to a DSN(= MM) and to a table "PRT"
The form also has an unbound listbox "List1".
I want to fill the listbox with data linked to a textbox on "frm1280"
I need some help with an SQL statement to fill the list.
<pre>Dim strSQL As String
strSQL = "SELECT PRT.EST_NO, PRT.SUP_NO, PRT.ITM_DES, PRT.QTY, PRT.NET_CST, PRT.RET_CST
FROM PRT WHERE (((PRT.EST_NO)=frm1280!txtEST);"
Once I have filled the list, I should be ok with a number of things I want to do with the data.