Hi,
I have a linked table called tbltest and some bounded forms (which
add, update, delete records) that were created using that linked
table. For some necessary reasons I had to create another linked table
called tblComponents and then I bounded the original forms to this new
table. I did change the
control source: Description (Field name)
RowSource Type: Table/Query (which remains the same)
Row Source: Select Distinct [tblComponents].[Description] from
tblComponents where ((([tblComponents].[Description] is not Null));
Basically for the RowSource I changed the tbltest to tblComponents.
But now when I run the form it gives the following error:
THe Microsoft Jet database engine cannot find the input table or query
'tbltest'. Make sure it exists and that its name is spelled correctly.
The bounded forms control were created using the wizard. Is there a
way to fix this problem without creating the form with the various
controls again from scratch.
Thanks for any fixes/ideas.
SA
