Combo box wizard gives error message:

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

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
 
The wizard does not get to the stage of producing a Row Source because the
error message "Syntax error in From clause" intervenes.
 
Thanks, I fixed it by making the RowSource equal to an actual query and not
an SQL statement.
 
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.
 
Back
Top