I have a database which has worked fine for years. I developed it for a business and maintain it. The business uses it in a networked environment, with the main file on each machine and data file on the server.. One of their machines had some problems and now the database isn't working properly on any machine. When I copy both files back to my machine it works fine. One of the issues is that we have a main form with several subforms. One of those is set as continuous forms so they can add as many products as they need. Suddenly it won't allow them to add another product. And if they set up a new booking in the main form they can't add a product because there is no subform. We can work around it by going to the table and adding just enough info to trigger the subform, then go to the form itself to add the rest of the info.
I can't see what is different when I run it on my machine so I can sort it out on the other.
I have checked the Tools/References for both files on both machines and there is nothing different there.
Does anyone have a suggextion please?
Lorraine in Hokitika NZ