On Jul 2, 11:43=A0am, Salad <o...@[EMAIL PROTECTED]
> wrote:
> agarwasa2...@[EMAIL PROTECTED]
wrote:
> > On Jul 2, 11:35 am, 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
tb=
lTest.
>
> >>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.
>
> The form has a property sheet. =A0The controls; combos, listbox,
textbox,
> labels...they have a property sheet as well. =A0The recordsource is the
> recordset associated with the entire form. =A0So if the form's
> recordsource is using an invalid table, you need to open the property
> sheet of the form. =A0Open 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. =A0A 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
|
