D
Dinky
That's because when you create a #temp table (or a table with a SPID column)
for display on a form or report you cannot use the .recordsource property. Of
course you can use the .recordset property to resolve this issue because you
can create your own connection, execute a recordset and the pass the
recordset back to the form or report that need it. The problem with the
..recordset property is that it is very fragile. It crashes Access if you try
to filter on the form and also when you try to update a True/False field.
Another suggestion to Microsoft will be to introdure a Connection property
(Get/Set) to the form or report. That's the best solution and will avoid
annoyances such as the above
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...4b75&dg=microsoft.public.access.modulesdaovba
for display on a form or report you cannot use the .recordsource property. Of
course you can use the .recordset property to resolve this issue because you
can create your own connection, execute a recordset and the pass the
recordset back to the form or report that need it. The problem with the
..recordset property is that it is very fragile. It crashes Access if you try
to filter on the form and also when you try to update a True/False field.
Another suggestion to Microsoft will be to introdure a Connection property
(Get/Set) to the form or report. That's the best solution and will avoid
annoyances such as the above
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...4b75&dg=microsoft.public.access.modulesdaovba