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

agarwasa2008@gmail.com

Guest

n/a Posts

July 2nd, 2008
06:35 PM
#2

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

On Jul 2, 11:16*am, agarwasa2...@gmail.com wrote:

Quote:

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

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

Salad

Guest

n/a Posts

July 2nd, 2008
06:45 PM
#3

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

Join Bytes! wrote:

Quote:

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

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.

Freestyler
http://www.youtube.com/watch?v=cFjlB_O1WpI

agarwasa2008@gmail.com

Guest

n/a Posts

July 2nd, 2008
06:45 PM
#4

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

On Jul 2, 11:35*am, Salad <o...@vinegar.comwrote:

Quote:

agarwasa2...@gmail.com wrote:

Quote:

Hi,

Quote:

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

Quote:

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));

Quote:

Basically for the RowSource I changed the tbltest to tblComponents.
But now when I run the form it gives the following error:

Quote:

THe Microsoft Jet database engine cannot find the input table or query
'tbltest'. Make sure it exists and that its name is spelled correctly.

Quote:

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.

Quote:

Thanks for any fixes/ideas.

Quote:

>
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 -

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

Salad

Guest

n/a Posts

July 2nd, 2008
06:45 PM
#5

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

Join Bytes! wrote:

Quote:

On Jul 2, 11:35 am, Salad <o...@vinegar.comwrote:
>

Quote:

>>agarwasa2...@gmail.com wrote:
>>

Quote:

>>>Hi,

Quote:

>>>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

Quote:

>>>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));

Quote:

>>>Basically for the RowSource I changed the tbltest to tblComponents.
>>>But now when I run the form it gives the following error:

Quote:

>>>THe Microsoft Jet database engine cannot find the input table or query
>>>'tbltest'. Make sure it exists and that its name is spelled correctly.

Quote:

>>>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.

Quote:

>>>Thanks for any fixes/ideas.

Quote:

>>>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. Click the ... to see if the recordsource uses tblTest.
>>
>>Freestylerhttp://www.youtube.com/watch?v=cFjlB_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.

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.

agarwasa2008@gmail.com

Guest

n/a Posts

July 2nd, 2008
06:55 PM
#6

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

On Jul 2, 11:43*am, Salad <o...@vinegar.comwrote:

Quote:

agarwasa2...@gmail.com wrote:

Quote:

On Jul 2, 11:35 am, Salad <o...@vinegar.comwrote:

Quote:

>agarwasa2...@gmail.com wrote:

Quote:

>>Hi,

Quote:

>>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

Quote:

>>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));

Quote:

>>Basically for the RowSource I changed the tbltest to tblComponents.
>>But now when I run the form it gives the following error:

Quote:

>>THe Microsoft Jet database engine cannot find the input table or query
>>'tbltest'. Make sure it exists and that its name is spelled correctly.

Quote:

>>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.

Quote:

>>Thanks for any fixes/ideas.

Quote:

>>SA

Quote:

>Are you needing to update the Recordsource of the form or the rowsource
>of a combo box?

Quote:

>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.

Quote:

>Freestylerhttp://www.youtube.com/watch?v=cFjlB_O1WpI-Hide quoted text-

Quote:

>- Show quoted text -

Quote:

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

>
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 -

Yes that ought to do it. Thank you very very ..... much. I should have
thought of it too. Regarding your question I am using a combos because
the user can select some values from the existing table or simply add
new ones to this field if needed.

Thanks agin for your help,
SA