Adding new records to table

[JamesN]

Hi,

I had a front end form and back end table, the form was used to add new records to the table. It previously worked fine, however recently i've noticed that the VBA code is running fine without any errors but no records are being added. Currently just a local database but tables and forms will be published on Sharepoint once resolved.

Any ideas what the issue is.

Cheers

James

 

[CJ_London]

no idea at all without seeing the code. To debug do the following

1.ensure you have Option Explicit at the top of each module
2.comment out any setwarnings/on error goto lines to identify if any errors are generated.
3.Then step through the code line by line and check that it is doing what it is supposed to do.

If you still cannot see the issue, post the code and confirm what is happening at each step.