I've converted the BE to SQL Server & a previous listbox is causing the above error. I've removed all event associations with the form & commented out the code in VBA but I still get the prompt. It is strange that it is only this listbox (where there are many other controls on the form) which is causing this error.
I am trying to base the old listbox on a PT Query based on a view in SQL Server. The view works fine in Access (from the view itself) but when trying to put it in the already existing listbox I get the error. I get the error regardless when opening the form.
I can create a new listbox in the existing form & it works fine but I am curious as to why this is happening & how to locate the exact error?
I am trying to base the old listbox on a PT Query based on a view in SQL Server. The view works fine in Access (from the view itself) but when trying to put it in the already existing listbox I get the error. I get the error regardless when opening the form.
I can create a new listbox in the existing form & it works fine but I am curious as to why this is happening & how to locate the exact error?
