I'm having brain fade today...
Can the recordsource in a Form's properties do more than one select
statement based on criteria?
On a popup subform I'm trying to display matching records from a table if
MarketPlaceID on the parent form (frmCustomerOrders) matches MarketPlaceID
from this table (tempOrders). If there are no matches I want it to display
data from this table where there is nothing in the OrderID field.
I can't seem to combine these two statements in the recordsource, separately
they would look like this....
SELECT [tempOrders].* FROM [tempOrders] WHERE
((([tempOrders].[MarketPlaceID])=[Forms]![frmCustomerOrders]![MarketPlaceID]
));
or else:
SELECT [tempOrders].* FROM [tempOrders] WHERE ((([tempOrders].OrderID) Is
Null));
I'm thinking that maybe the recordsource properties isn't the correct way to
achieve this kind of filtering?
Thanks
Alan