Sorry I found the issue it wasnt a code error at all. It was something happening in the connection.
Resolved and I got busy working on the next part, so lost the thread for a while.
Thanks for the help.
Hi Mark
Reading the post the best way to get help on this is show us your tables and the query. Ideally show us the tables in design view and the query in SQL and we should then be positioned to best help.
I suspect from the description the underlying structure is the issue.
Hope that helps.
Hi
Well as no one has had a stab at this, and I admit to some confusion about what is intended perhaps something like this may work.
Timer event
Save which Control is in focus - Send control name to an invisible field on the main or sub form wont matter too much as long as you know where it...
Hi
I use this method a fair bit in my current project. To the point I am considering making a module to take the form name and SQL and process at one point for all of this project...a lot.
However it is failing me on using on a sub form. I have spent a good 40 minutes looking about on line...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.