Ok, so.. I posted in the forms section and now realize my problem probably should be in here! Thanks in advance for any help, i truely appreciate it.
Here's the problem:
I have a master form, a top subform of orders in datasheet view, and bottom subform that populates with what order you have selected in the top datasheet. In the bottom subform there is a subsub form that shows, in datasheet view, items that are linked to that order you have selected.
there is an item type table [invMats] that associates all available items with what kind of item they are.
Now, on the master form i have a dropdown [selectType] that filters the orders based upon what type of items are associated with that order.
If the dropdown box is null, it will bring up all orders with all items, as it should. and if you select a type in the dropdown, it will sort the orders based upon if it has items linked to it that are of that type.
It all works flawlessly, aside from one little problem. If an order has no items on it at all, then that order will not show up if the dropdown box is null, or populated. So essentially all orders that don't have any items (including new orders) will never show up.
The SQL that accomplishes this, is on the top orders subform (the datasheet one) and looks as follows:
SELECT POs.*
FROM POs INNER JOIN (invMats INNER JOIN invRec ON invMats.matID = invRec.matID) ON POs.PO = invRec.dbPO
WHERE (((IIf([Forms]![POmaster]![selectType] Is Null,"",((([invMats].[dept])=[Forms]![POmaster]![selectType]))))<>False));
I need something in the truepart that will allow the Where condition to show all orders.. regardless of items..
thank you for the help!!!!