Need to change the table for bounded Forms !!

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

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

agarwasa2...@gmail.com wrote:>>>>>>>>
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. *Click the ... to see if the recordsource uses tblTest.
>
Freestylerhttp://www.youtube.com/watch?v=cFjlB_O1WpI- Hide quoted text -
>
- Show quoted text -

On Jul 2, 11:35 am, Salad <o...@vinegar.comwrote:
>>
>
You are right. I need to change the recordSource but I do not see that
property name in the data tab.

agarwasa2...@gmail.com wrote:>>>>>>>>>>>>>>>
The form has a property sheet. *The controls; combos, listbox, textbox,
labels...they have a property sheet as well. *The recordsource is the
recordset associated with the entire form. *So if the form's
recordsource is using an invalid table, you need to open the property
sheet of the form. *Open up the propertysheet for anything and press on
the square box in the upper left hand corner of the form window to get it..
>
I'm a bit confused with your question. *A combo box is good for lookups
and storing some to a field in the table.- Hide quoted text -
>
- Show quoted text -