Hi All,
I've got a very confusing problem, I'll try explain as best as I can!
I have written a query in Access 2013 which has data from a couple of different sources and displays information on a form. I can open the form and it will run fine and if I close the form but leave the main Access window open I can open the form and the query will run correctly. If I then close Access completely and open it again and then open the form the query won't run. The only way I can fix it is to compact and repair and then the query works fine again until I close Access.
I have rewritten the query and run it in a previous version of my DB and it does the same thing.
Any ideas please??
Thanks
I've got a very confusing problem, I'll try explain as best as I can!
I have written a query in Access 2013 which has data from a couple of different sources and displays information on a form. I can open the form and it will run fine and if I close the form but leave the main Access window open I can open the form and the query will run correctly. If I then close Access completely and open it again and then open the form the query won't run. The only way I can fix it is to compact and repair and then the query works fine again until I close Access.
I have rewritten the query and run it in a previous version of my DB and it does the same thing.
Any ideas please??
Thanks