I Applied same Code on a dummy form, it worked, but when i tried it on to a Genuine <Purchase> form on which I want to work, it is not updating record, even every code Syntax is same bit by bit, i cant know where i m doing mistake, whether it is in Database file or in Binding Textboxes with Database or with update statement, Because it returns <Syntax error in INSERT INTO statement.> Error Message, plz help me finding error and mistake,
I m Attaching a zip file,
yes its database file is placed inside Project Folder
<\tryitagain\tryitagain\bin\Debug> file name Is tryitagaindata.mdb
and in coding to return Projects' path where database file is placed i used following Code
Pth = My.Application.Info.DirectoryPath
and in Connectin.connectionstring i used <Pth> Variable to Connect with database as follows
Data Source=" & Pth & "\tryitagaindata.mdb; User Id=admin; Password=;"
here in this project Two forms are added based on same Coding, one of them <Form1> is Working but second one <PurchaseOk> is not working, yes both forms are connected with same Database files but separate tables.
Form Form1 is connected with Tblmaster (Table), and Form Purchaseok is Connected with PurchaseTbl (Table)
Plz Find Project Attachment zip file
Help with this problem or to find out mistakes and error plz
Regards and Best Wishes
Fahad