Hi
I have 2 comboboxes (Combo9 and ProductCode) on a subform (fmSalesOrderDetails) on a form (fmOrderDetails)
When I use the subform as a form it works great. But now it's part of a form it gives me the following error message when I click on the ProductCode combobox:
forms!fmSalesOrder!fmSalesOrderDetails.Form!Combo9
The syntax behind the row source for ProductCode combobox is:
SELECT distinct tblProducts.ID, tblProducts.Description, tblProducts.RetailPrice FROM tblProducts WHERE ((tblProducts.AntiqueRepro)=[forms]![fmSalesOrder]![fmSalesOrderDetails].Form![Combo9]) UNION select distinct null, null, null FROM tblProducts
ORDER BY tblProducts.Description;
Where am I going wrong?
Thanks
Tracey
I have 2 comboboxes (Combo9 and ProductCode) on a subform (fmSalesOrderDetails) on a form (fmOrderDetails)
When I use the subform as a form it works great. But now it's part of a form it gives me the following error message when I click on the ProductCode combobox:
forms!fmSalesOrder!fmSalesOrderDetails.Form!Combo9
The syntax behind the row source for ProductCode combobox is:
SELECT distinct tblProducts.ID, tblProducts.Description, tblProducts.RetailPrice FROM tblProducts WHERE ((tblProducts.AntiqueRepro)=[forms]![fmSalesOrder]![fmSalesOrderDetails].Form![Combo9]) UNION select distinct null, null, null FROM tblProducts
ORDER BY tblProducts.Description;
Where am I going wrong?
Thanks
Tracey