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

On Jul 2, 11:35=A0am, Salad <o...@[EMAIL PROTECTED]
> wrote:
> 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
>
> Are you needing to update the Recordsource of the form or the rowsource
> of a combo box?
>
> Open up the form in design mode and open the form's property sheet.
> Press the Data tab. =A0Click the ... to see if the recordsource uses
tblTe=
st.
>
> Freestylerhttp://www.youtube.com/watch?v=3DcFjlB_O1WpI-
Hide quoted text
-=

>
> - Show quoted text -

You are right. I need to change the recordSource but I do not see that
property name in the data tab.