R
rick.bresin
I'm using the following rowsource query to filter a combobox
SELECT Products.ProductID, Products.ProductName, Products.PartNumber,
Products.UnitPrice, Products.ModelNum
FROM Products
WHERE (((Products.ModelName)=[Model]));
Model is textbox on the form
This works fine to filter the list to a specific Model but if the
Model is Null the combo box shows no records. How can I alter the
rowsource to still filter according to model name but show all products
if Model textbox is null?
Is It better to set rowsource in code somewhere or would it be better
for me to learn how to create a filter for this subform?
I've searched the group but haven't found anything that quite applies.
SELECT Products.ProductID, Products.ProductName, Products.PartNumber,
Products.UnitPrice, Products.ModelNum
FROM Products
WHERE (((Products.ModelName)=[Model]));
Model is textbox on the form
This works fine to filter the list to a specific Model but if the
Model is Null the combo box shows no records. How can I alter the
rowsource to still filter according to model name but show all products
if Model textbox is null?
Is It better to set rowsource in code somewhere or would it be better
for me to learn how to create a filter for this subform?
I've searched the group but haven't found anything that quite applies.