Form not writing data to table

[Ancil Jones]

I have a database that I have been using for over a year w/o difficulty. I made some cosmetic changes to use it in another area (same job, different aircraft). The only real change I made was re-creating the tblMstrLog which auto-assigns a log number. I had to re-create the table bacause I could not get it to re-start autonumber. The form is receiving the log numbers from the table, but the data entered into the form is not being written to the table.

I now also have issues with the tables abiding by relationship restrictions.

Any assistance would be greatly appreciated.

Thank you.

[xordevoreaux]

Using just MS Access with an .mdb file or as an MS Access project (.adp) file as a front end to an MDSE / SQL server?

Which version of Access?

[Ancil Jones]

Access 2000 and mdb to answer your questions.

However, thank you all for pondering the question. I finally figured out that it was a relationship issue. One of the tables had become different enough that it wasn't allowing the data to be added to the table according to the one to one relationship restrictions. It was not capturing the event and reporting the error.

The situation has been resolved.

Thanks again.