Records stopped updating

[smithdon53]

Hi
I have a access 2007 database that I created in access for entering flight information in our aero club. The form allows the user to choose the aircraft, pilot and flight time. It then calculates the flight cost( the cost is pulled from another table) The record is saved in the " Flight information Table" This was working fine and all of the sudden the table no longer updates. Whwn you input from the form everything shows up on the form corectly ie the flight cost, minutes flown.....but the data doesnt go to the table any more......almos t like the the form and table are not associated any more. One thing to add is that it stopped working correctly when I updated some records directly in the table rather than going in through the form. I have attached the access file.


Ok I noticed that if I add a new record the autoincrement key apears on the form ok , its one number greater than the last record, however if I close out the form and open again the new record....

Thanks

[missinglinq]

When posting questions, especially when attaching a database file, please be sure to note that you are running Access 2007!

Many people lurking in these hallowed halls of learning are still not running this version, and downloading a copy of your db is a total waste of time for them, as they cannot open it.

In addition, v2007 is different in so many ways that it can make a big difference is how the experts here answer your questions.

Welcome to Bytes!

Linq ;0)>

[smithdon53]

When posting questions, especially when attaching a database file, please be sure to note that you are running Access 2007!

Many people lurking in these hallowed halls of learning are still not running this version, and downloading a copy of your db is a total waste of time for them, as they cannot open it.

In addition, v2007 is different in so many ways that it can make a big difference is how the experts here answer your questions.

Welcome to Bytes!

Linq ;0)>

Done........any Idea whats going on with this ?

[smithdon53]

Hi
I have a access 2007 database that I created in access for entering flight information in our aero club. The form allows the user to choose the aircraft, pilot and flight time. It then calculates the flight cost( the cost is pulled from another table) The record is saved in the " Flight information Table" This was working fine and all of the sudden the table no longer updates. Whwn you input from the form everything shows up on the form corectly ie the flight cost, minutes flown.....but the data doesnt go to the table any more......almos t like the the form and table are not associated any more. One thing to add is that it stopped working correctly when I updated some records directly in the table rather than going in through the form. I have attached the access file.


Ok I noticed that if I add a new record the autoincrement key apears on the form ok , its one number greater than the last record, however if I close out the form and open again the new record....

Thanks

Wow what a helpful site