Dear MS,
I have a problem with a converted Access DB.
The database was originally in Access 2.0 format and now it has been converted to Access 2007 format in multiple steps.
Most functionality problem could be easily fixed, however, there is one problem for which I could not figure out any solution yet.
Some forms use query as their recordsource. When opening the form run-time the recordset is empty. When I run the same query alone, it is run correctly roducing the proper recordset. I also tried to alter the recordset on the form load event changing it explicitely
but it did not work out well either.
The query contains a parameter gathered from a parent form so if the parameter is not present it pops up an edit box to fill. This is a good indicator for checking if the query is run, by not providing an value for the parameter.
The fact is, when I run the Descendent form without providing parameter, the form opens without asking for the value, using empty recordset. This makes me think that the recordsource query is for some reason not run when loading the form, though it should be.
I also tried creating a new form as a last solution, using the same query as a recordsource and it worked pretty fine. Still, I am hoping there is an easier solution for this problem, rather than recreating like 20 forms in my database.
Do you guys have any ideas?
