View Full Version : A little prompting needed


sent1nel
08-20-2000, 09:14 PM
The situation is this: I have a form that has several fields that are all grouped by month. I want to be able to have a popup appear, whenever the user opens the form, that allows the user to specify which month's records they view.

andyh
08-22-2000, 06:24 AM
assuming that the forms info is based on a query (if not - make it so), type the following in the criteria line of the query field holding the date or month info

[please type the month for analysis]

then a box appears asking for the user to specify the month for analysis

if you want to specify a start date and end date for a range of dates type

Between [enter start date] And [enter the end date]

then you gert two boxes (start and end date)