How to make a pop up query

[Frank Situmorang]

I have a form as follows:

Main form is supplier and subform is invoices and the mainform ans subform
is based on a grid query:

The layout is more or less as follows:
Main form
Supplier no :------

Supllier Name:_________

subform:
Job No. Inv. Number Inv. Date Amount Paid Inv. Bal Pay Ref
--------- -------------- -------- -------- ------ ---------
--------

Normally I put the curson on the Supplier name and hit Access Icon Filter by
Form and I can view the outstanding invoices for the selected supplier.

Since the clerck keep keying incoming invoices, while I want only invoice
upto Dec 31 2007, to be shown. How can I make a promtting query to show up
only Invoice Date upto Dec 31, 2007. So soemthing is like multi level query

I appreciate your helping me on this.


H. Frank Situmorang