I have a main form "FrmCustPrice" based on a query "QryAddresses."

This "FrmCustPrice" has a subform called "FrmCustPriceListSUB" and it was
formed via the subform/subreport wizard which gave the following

SELECT QryCustPrice.ProductID, Products.Description, Products.Unit,
QryCustPrice.ItemPrice, QryCustPrice.CustProductCode,
QryCustPrice.AddressesID FROM Products INNER JOIN QryCustPrice ON
Products.ProductID = QryCustPrice.ProductID;

The main form & subform are linked via "AddressesID"

On the main form I am trying to make a Combo box to find a record on it,
but the combo wizard gives the following error message:

"Syntax error in From clause."

I have Access2000
Please help, Frank

Try posting the Row Source of the combo box. Then maybe someone can
help.

On Thu, 6 Jan 2005 12:14:33 +1100, "Frank Martin"
<(E-Mail Removed)> wrote:

>I have a main form "FrmCustPrice" based on a query "QryAddresses."
>
>This "FrmCustPrice" has a subform called "FrmCustPriceListSUB" and it was
>formed via the subform/subreport wizard which gave the following
>
>SELECT QryCustPrice.ProductID, Products.Description, Products.Unit,
>QryCustPrice.ItemPrice, QryCustPrice.CustProductCode,
>QryCustPrice.AddressesID FROM Products INNER JOIN QryCustPrice ON
>Products.ProductID = QryCustPrice.ProductID;
>
>The main form & subform are linked via "AddressesID"
>
>On the main form I am trying to make a Combo box to find a record on it,
>but the combo wizard gives the following error message:
>
>"Syntax error in From clause."
>
>I have Access2000
>Please help, Frank
>
>

The wizard does not get to the stage of producing a Row Source because the
error message "Syntax error in From clause" intervenes.



"Penguin" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Try posting the Row Source of the combo box. Then maybe someone can
> help.
>
> On Thu, 6 Jan 2005 12:14:33 +1100, "Frank Martin"
> <(E-Mail Removed)> wrote:
>
> >I have a main form "FrmCustPrice" based on a query "QryAddresses."
> >
> >This "FrmCustPrice" has a subform called "FrmCustPriceListSUB" and it was
> >formed via the subform/subreport wizard which gave the following
> >
> >SELECT QryCustPrice.ProductID, Products.Description, Products.Unit,
> >QryCustPrice.ItemPrice, QryCustPrice.CustProductCode,
> >QryCustPrice.AddressesID FROM Products INNER JOIN QryCustPrice ON
> >Products.ProductID = QryCustPrice.ProductID;
> >
> >The main form & subform are linked via "AddressesID"
> >
> >On the main form I am trying to make a Combo box to find a record on it,
> >but the combo wizard gives the following error message:
> >
> >"Syntax error in From clause."
> >
> >I have Access2000
> >Please help, Frank
> >
> >
>

Thanks, I fixed it by making the RowSource equal to an actual query and not
an SQL statement.



"Penguin" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Try posting the Row Source of the combo box. Then maybe someone can
> help.
>
> On Thu, 6 Jan 2005 12:14:33 +1100, "Frank Martin"
> <(E-Mail Removed)> wrote:
>
> >I have a main form "FrmCustPrice" based on a query "QryAddresses."
> >
> >This "FrmCustPrice" has a subform called "FrmCustPriceListSUB" and it was
> >formed via the subform/subreport wizard which gave the following
> >
> >SELECT QryCustPrice.ProductID, Products.Description, Products.Unit,
> >QryCustPrice.ItemPrice, QryCustPrice.CustProductCode,
> >QryCustPrice.AddressesID FROM Products INNER JOIN QryCustPrice ON
> >Products.ProductID = QryCustPrice.ProductID;
> >
> >The main form & subform are linked via "AddressesID"
> >
> >On the main form I am trying to make a Combo box to find a record on it,
> >but the combo wizard gives the following error message:
> >
> >"Syntax error in From clause."
> >
> >I have Access2000
> >Please help, Frank
> >
> >
>

Your RowSource can be an SQL statement. If you receive an error then
copy the SQL statement from the combo box and paste it into a query.
Run the query to find the error. Once corrected then copy the SQL of
the query back to the combo box.

On Fri, 7 Jan 2005 13:53:47 +1100, "Frank Martin"
<(E-Mail Removed)> wrote:

>Thanks, I fixed it by making the RowSource equal to an actual query and not
>an SQL statement.
>
>
>
>"Penguin" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> Try posting the Row Source of the combo box. Then maybe someone can
>> help.
>>
>> On Thu, 6 Jan 2005 12:14:33 +1100, "Frank Martin"
>> <(E-Mail Removed)> wrote:
>>
>> >I have a main form "FrmCustPrice" based on a query "QryAddresses."
>> >
>> >This "FrmCustPrice" has a subform called "FrmCustPriceListSUB" and it was
>> >formed via the subform/subreport wizard which gave the following
>> >
>> >SELECT QryCustPrice.ProductID, Products.Description, Products.Unit,
>> >QryCustPrice.ItemPrice, QryCustPrice.CustProductCode,
>> >QryCustPrice.AddressesID FROM Products INNER JOIN QryCustPrice ON
>> >Products.ProductID = QryCustPrice.ProductID;
>> >
>> >The main form & subform are linked via "AddressesID"
>> >
>> >On the main form I am trying to make a Combo box to find a record on it,
>> >but the combo wizard gives the following error message:
>> >
>> >"Syntax error in From clause."
>> >
>> >I have Access2000
>> >Please help, Frank
>> >
>> >
>>
>