query criteria not bringing up any records

  • Thread starter Thread starter Isabelle
  • Start date Start date
I

Isabelle

I have an invoice database. I have made one form that creates a report
based on the employee who ordered the items. There are basically 3
fields on the form: start date, end date, and a combo box
[EmployeeListing]to choose the employee. In this form, I have the
criteria: [forms]![x_EmployeeOrders]![EmployeeListing] under the field
OrderedBy in the query. I tried to apply this same logic to a
different form that pulls up a report based on suppliers of the items.
There is again the start date, end date, and combo box
[SupplierListing]. I placed the criteria:
[forms]![x_OrdersBySupplier]![SupplierListing] under the field
SupplierName. But no data is pulled up when I try to use the combo box
to choose a supplier. I think the problem may be with the
relationships but I don't know how to figure that out. Does any one
have any suggestions? Thanks a bunch in advance!
 
Hi,


When the form is opened, try, in the immediate debug window:

? forms]![x_OrdersBySupplier]![SupplierListing]


you should get the value from the combo box (if any). If you don't, check
if the control is really in the form, rather than in a sub-form in the form.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top