I am workin with a superstore managment project. I connect Access database with main form . Then it work properly. But now I connect same database with another table or field in another form which is child of main form not working.
Main form stil working but when try to open child a message show as
Please select a valid SQL statement as "Select", "Delet" or "Updat"
I am working with Access . I connect database in same way . but mainform working and child form not working .
** Pont**
I link child form as
Dim child As New frmlogin()
frmmain Load_Event(... ...... ......)...
child.ShowDialog()
my code for data connection is as in load event .....
m_cnADOConnection.Open("Provider=Microsoft.jet.OLE DB.4.0;" & _
"Data source = C:\G3SP\G3SP.mdb")
m_rstProduct.Open("Product", m_cnADOConnection, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockBatchOptimistic)
Please Someone help me ?
Thanking u
Asad