Re: Need to change the table for bounded Forms !!

On Jul 2, 11:16=A0am, agarwasa2...@[EMAIL PROTECTED]
 wrote:
> Hi,
>
> I have a linked table called tbltest and some bounded forms (which
> add, update, delete records) =A0that 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

I forgot to add that all the bounded controls are combo Boxes and also
I would like to make the changes in the properties window rather than
code if possible.

Thanks again,
SA