How can I use a Select from a temporary as rowsource for a combobox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

We are developing an application that uses SQL Server as Database Backend and Access 2000 as frontend
For design reasons we use some temporary table to manage data related to the user profile, but, when we use a select to one of that temporary tables as rowsource for a combobox Access returns the following error
"The recordsource ..... for this form or control does not exist"
Our surprise came when we try to use the same Select as recordSource for a form and that works perfectly

Is there a limitation that prevents from use a temporary table as rowsource for concret controls?

cam somebody tell us how to work with temporary tables with access 2000

thanks to much
 
As far as I know, Access does not care if the table is temporary. It is
temporary to you, the designer, but for Access - if its created, its
there; if its deleted - oh well, bye-bye.
I think the problem is with some syntax issues or mistakingly putting
the SQL statement into a wrong property of the combo box (*record*
source instead of the *row* source, after seeing "The >>recordsource<<
...... for this form or control does not exist").

Pavel
 
Back
Top