Question about criteria field in queries

[darylclassen]

I've built an application to enter and print out reports for my company. To choose which report to print, I've entered [Enter Invoice #:] into the criteria field of a query the report pulls the invoice number from. Is it possible to set the criteria field to some statement that will give a list of available Invoice #s to choose from when the report is run, rather then having to enter it manually? Thanks in advance.

 

[JeremyNYC]

You'll have to make a form with a combo box (or list box) that gets filled with all of the available data. There will be a button that fires off the report. The criteria for the query behind the report will look something like this: forms!frmCriteriaForMyReport!cmbInvoiceNumber.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Professional Development for Clients Large and Small

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[darylclassen]

Thanks for the help. Works perfectly!

 

[JeremyNYC]

Glad the post was helpful.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Professional Development for Clients Large and Small

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.