My apologies, it works fine now and amazingly fast. 3 second load! However, the reason why I wanted to use the DataEntry property was so I can set it off when i use my Edit Survey button. I don't know how to do that with this query. However, this has shown me that a faster form is possible and...
The query record source works great on the database when i split it locally but the form does not open when i split the back end to the server. Could it be an issue with the server not giving the same permissions as I would have locally?
Hi peeps,
I have an issue with the DataEntry property causing my form to be only useable by one user at a time.
I've made a split database with the backend holding the survey response table on the slow company server, while the frontend is the survey form. It's been working fine although...