J
Jae Hood
Hi,
I have an order lookup form which is currently designed in 3 tabs which hold
subforms to lookup orders by status, customers, and suppliers.
Now i'm trying to combine these 3 subforms into one main form where you can
lookup orders based on those 3 criteria and maybe even by date range.
The way it is now I have a combo box with the values
"open;shipping;closed;dead" as a row source, the end user selects one of
those values and the form requeries and shows only the orders with the
selected status.
The same method is used for customers and suppliers except the row source is
taken directly from the customers/suppliers table.
I'm using this criteria in my respective subform queries:
[Forms]![Order Lookup]![By Status]![StatusSelect]
[Forms]![Order Lookup]![By Customer]![CustSelect]
[Forms]![Order Lookup]![By Supplier]![SuppSelect]
When I try to combine the criterias into a common query and use 3 combo
boxes, no relevant information appears on the form. I'm not getting any error
message either.
What am I doing wrong?
Thank you so much.
I have an order lookup form which is currently designed in 3 tabs which hold
subforms to lookup orders by status, customers, and suppliers.
Now i'm trying to combine these 3 subforms into one main form where you can
lookup orders based on those 3 criteria and maybe even by date range.
The way it is now I have a combo box with the values
"open;shipping;closed;dead" as a row source, the end user selects one of
those values and the form requeries and shows only the orders with the
selected status.
The same method is used for customers and suppliers except the row source is
taken directly from the customers/suppliers table.
I'm using this criteria in my respective subform queries:
[Forms]![Order Lookup]![By Status]![StatusSelect]
[Forms]![Order Lookup]![By Customer]![CustSelect]
[Forms]![Order Lookup]![By Supplier]![SuppSelect]
When I try to combine the criterias into a common query and use 3 combo
boxes, no relevant information appears on the form. I'm not getting any error
message either.
What am I doing wrong?
Thank you so much.