Hello,
I have a form and subform . The Main form contains four boxes to enter criteria for the query that fills the subform. Outside of the navigation form it works great. when i add it to the navigation form on open the access paramter box pops up asking for criteria instead of just letting me enter it on the form. Is there a problem using this type of form in a navagation form.
SQL for Query:
SELECT Orders.[Employee ID], Orders.[Order Date], Orders.Received , Orders.Vendor, Orders.Quantity , Orders.[Ace Number], Orders.Descript ion, Orders.Points, Orders.Price, [Quantity]*[Price] AS [Total Sales]
FROM Orders
WHERE (((Orders.[Employee ID])=[Forms]![OBE]![txtem]) AND ((Orders.[Order Date]) Between [Forms]![OBE]![txtstart] And [Forms]![OBE]![txtend]) AND ((Orders.Vendor )=[Forms]![OBE]![txtvendor])) OR (((Orders.[Order Date]) Between [Forms]![OBE]![txtstart] And [Forms]![OBE]![txtend]) AND ((Orders.Vendor )=[Forms]![OBE]![txtvendor]) AND (([Forms]![OBE]![txtem]) Is Null)) OR (((Orders.[Employee ID])=[Forms]![OBE]![txtem]) AND ((Orders.Vendor )=[Forms]![OBE]![txtvendor]) AND (([Forms]![OBE]![txtstart]) Is Null)) OR (((Orders.Vendo r)=[Forms]![OBE]![txtvendor]) AND (([Forms]![OBE]![txtem]) Is Null) AND (([Forms]![OBE]![txtstart]) Is Null)) OR (((Orders.[Employee ID])=[Forms]![OBE]![txtem]) AND ((Orders.[Order Date]) Between [Forms]![OBE]![txtstart] And [Forms]![OBE]![txtend]) AND (([Forms]![OBE]![txtvendor]) Is Null)) OR (((Orders.[Order Date]) Between [Forms]![OBE]![txtstart] And [Forms]![OBE]![txtend]) AND (([Forms]![OBE]![txtem]) Is Null) AND (([Forms]![OBE]![txtvendor]) Is Null)) OR (((Orders.[Employee ID])=[Forms]![OBE]![txtem]) AND (([Forms]![OBE]![txtstart]) Is Null) AND (([Forms]![OBE]![txtvendor]) Is Null)) OR ((([Forms]![OBE]![txtem]) Is Null) AND (([Forms]![OBE]![txtstart]) Is Null) AND (([Forms]![OBE]![txtvendor]) Is Null))
ORDER BY Orders.[Employee ID], Orders.[Order Date] DESC;
Thanks
I have a form and subform . The Main form contains four boxes to enter criteria for the query that fills the subform. Outside of the navigation form it works great. when i add it to the navigation form on open the access paramter box pops up asking for criteria instead of just letting me enter it on the form. Is there a problem using this type of form in a navagation form.
SQL for Query:
SELECT Orders.[Employee ID], Orders.[Order Date], Orders.Received , Orders.Vendor, Orders.Quantity , Orders.[Ace Number], Orders.Descript ion, Orders.Points, Orders.Price, [Quantity]*[Price] AS [Total Sales]
FROM Orders
WHERE (((Orders.[Employee ID])=[Forms]![OBE]![txtem]) AND ((Orders.[Order Date]) Between [Forms]![OBE]![txtstart] And [Forms]![OBE]![txtend]) AND ((Orders.Vendor )=[Forms]![OBE]![txtvendor])) OR (((Orders.[Order Date]) Between [Forms]![OBE]![txtstart] And [Forms]![OBE]![txtend]) AND ((Orders.Vendor )=[Forms]![OBE]![txtvendor]) AND (([Forms]![OBE]![txtem]) Is Null)) OR (((Orders.[Employee ID])=[Forms]![OBE]![txtem]) AND ((Orders.Vendor )=[Forms]![OBE]![txtvendor]) AND (([Forms]![OBE]![txtstart]) Is Null)) OR (((Orders.Vendo r)=[Forms]![OBE]![txtvendor]) AND (([Forms]![OBE]![txtem]) Is Null) AND (([Forms]![OBE]![txtstart]) Is Null)) OR (((Orders.[Employee ID])=[Forms]![OBE]![txtem]) AND ((Orders.[Order Date]) Between [Forms]![OBE]![txtstart] And [Forms]![OBE]![txtend]) AND (([Forms]![OBE]![txtvendor]) Is Null)) OR (((Orders.[Order Date]) Between [Forms]![OBE]![txtstart] And [Forms]![OBE]![txtend]) AND (([Forms]![OBE]![txtem]) Is Null) AND (([Forms]![OBE]![txtvendor]) Is Null)) OR (((Orders.[Employee ID])=[Forms]![OBE]![txtem]) AND (([Forms]![OBE]![txtstart]) Is Null) AND (([Forms]![OBE]![txtvendor]) Is Null)) OR ((([Forms]![OBE]![txtem]) Is Null) AND (([Forms]![OBE]![txtstart]) Is Null) AND (([Forms]![OBE]![txtvendor]) Is Null))
ORDER BY Orders.[Employee ID], Orders.[Order Date] DESC;
Thanks