Thanks Minty! Sorry it took so long to reply. Utility workers inadvertently cut my internet cable so I couldn,t get online. I'm now at an outside venue with a public wifi so won't say any more right now. I do appreciate your reply!Yup
You are only returning unique records, which effectively groups them making the recordsource not editable .Code:
SELECT [COLOR="Red"]DISTINCTROW [/COLOR]MyTbl.* FROM MyTbl;
As hint for future debugging of similar issues, simply paste your rowsource into the query editor and see if you can edit the data.
Thanks for your reply Isladogs. See my reply to Minty above to understand my current internet situation. Hopefully, I'll be back up and running tomorrow or Saturday.Try removing DISTINCTROW. Not needed if you only have one table.
However I don't think that will solve it!
However, because of the "read-only" problem I was having with my custom pop-up form,
Thanks Cronk! Your suggestion is well taken.Going way back to #31
The pop up should only be collecting data and not bound, nor should any control be locked - same as an InputBox.
Maybe I missed something in my cursory reading of this thread but to repeat, the pop up is emulating the input box, merely collecting data. Processing should be in the calling form.
It crashed my program:banghead:sorry ax, i misunderstood
i thought you were aking how to make a programme wait.
I still feel it is better to understand why we need it to wait - and assuming its some sort of synchronisation issue, see if there is a more appropriate solution
in particular this code, without any doevents will just "hang" access - so you would vertainly want to put the hourglass up before doing it this way.