Combo box wizard gives error message:

[Frank Martin]

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

 

[Penguin]

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

 

[Frank Martin]

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

 

[Frank Martin]

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

 

[Penguin]

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.