By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,377 Members | 488 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,377 IT Pros & Developers. It's quick & easy.

Records stopped updating

P: 3
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......almost 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
Attached Files
File Type: zip Aero_ClubX.zip (4.21 MB, 34 views)
May 29 '10 #1
Share this Question
Share on Google+
3 Replies

missinglinq
Expert 2.5K+
P: 3,532
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)>
May 30 '10 #2

P: 3
@missinglinq
Done........any Idea whats going on with this ?
May 30 '10 #3

P: 3
@smithdon53
Wow what a helpful site
Jun 1 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.