Access 2003 to 2010

Topic

New Reply

We are moving to Office 2010 and have found that some of our Access databases do not work as they used to. This particular database has a form, which is used for data entry, and has two subforms as part of the data entry form. Each part of the form is entered into a different table. There is an auto number field to tie the three tables together. One of the tables links to the main form in a one-to-many format for transactions. The other table is linked one-to-one. It is the one-to-one subform that is not working in 2010.

During data entry the information can be entered in the main form and the subforms with no problems. The problem is that the subform does not display the information after moving to another record. The data is in the tables correctly. Reports have the right information, but the form does not display the information from the one-to-one table.

Any ideas?

Reply | Quote

Replies

Not knowing anything else, the only thing I can suggest is that you requery the subform in the current event of the mainform. Other than that, I’d have to see the database.

Reply | Quote

Thanks for the suggestion, Mark, but that didn’t help.

I’ve cut down the database as much as possible so you can look at it

Reply | Quote

You don’t say exactly what form does not show the data.
I notice that SRM KRAFT INFORMATION has a value in the filter property of the form. This would stop it display data most of the time.
I don’t this relates to the move to Access 2010.

Reply | Quote

Sorry, the FRM Drawing Information form contains the 2 sub forms. The Kraft Information form area does not display the information entered.

Reply | Quote

Have you tried removing the Filter from the Kraft Information subform? That worked for me.

Reply | Quote

Thanks, John. That seems to work. I will check with people who actually use the database to see if the Filter was on for a reason.

Reply | Quote