Form from Access 2003 won't work in Access 2019

[Calhoun98]

My son dragged me kicking and screaming into using Access 2019 after using maybe Access 95 (I started using Access in 1995 - I honestly don't remember what version it was) then 2003 since, well, 2003. I am a statistician for auto racing. I have a form for data entry where I key the results of each race. When I key the record number, it populates 8 more fields from a table with information tied to that record number (driver, car number, car make, tire, etc). When I try and open the form in 2019 I get this message.



Is there a simple answer easy fix? I've spent two days poking around the web and can't find anything. If you need the VB code or more info let me know. It was an absolute pain filling in every field manually this week. TIA for any help.

[Bob Fitz]

Can you post a copy of your db

[Micron]

In the vb editor go Tool>References and see if any are marked as missing and fix them. If not, hopefully you can still open the db in the older version (but I kinda doubt it) and compare the chosen references between the two. I think you're missing a reference or it is broken. If you have an old backup copy it is likely that you can get a list of those references. This is why I put them in a table in other projects.

[Calhoun98]

Well I feel silly. I created a new database - with the .accdb extension. I imported the three tables, the form, and the subform, and it all seems to be working fine. All my databases are in .mdb format. Is there something the form didn't like in the old format but it likes now in the .accdb format? Thanks for the help - all seems ok now.

[June7]

Well, references wouldn't have been broken in the new database.

Really can't say what caused issue without examining the mdb file.

I frequently open mdb files without issue (except for the annoying warning popup).

[Micron]

Well, references wouldn't have been broken in the new database.

True. I was just trying to cover off the possibility that somewhere along the way there was an OS update, which likely would cause that. Also, OP may not realize that if another db was part of the project and he moved or deleted it, I believe that would also cause a missing reference.

[Calhoun98]

Also, OP may not realize that if another db was part of the project and he moved or deleted it, I believe that would also cause a missing reference.

No other database involved. It is a stand-alone db. That's part of the reason I was baffled. I did the same thing to another db this afternoon (created a new one as a .accdb), imported all the tables, queries, forms, and reports and the form works just fine.