I have a form with a command button and a list box. The list box has the name of "$_importerrors" tables from within the current database. A user will select one of these values and click the command button. What I would like to do is change the record source of the called form so that the records in the selected '$_importerrors' table are displayed when the form opens.
I read that using recordsource = "SQL" would enable this to work but all I have it the report running against the table which I created it so recordsource isn't be changed.
Just to add some detail in case it helps;
Main form with the command button and listbox is called 'frmRefresh'
Called form with a datasheet view is called 'frmViewErrors"
It is 'frmViewErrors' that I need to have the recordsource change on
Any help appreciated.
Thanks.