starting and ending date

  • Thread starter Thread starter Deepak
  • Start date Start date
D

Deepak

Hi

In a datasheet form, i've following fields:

Phoneno nextrcduedate

I need the following help:

Whenever i open the form, i need a box to come up and ask for "starting
date" and "ending date" in mm/dd/yy format and thus, FILTER the form
(field= nextrcduedate) accordingly.

Kindly suggest

thanx for help

deepak
 
Deepak

Another approach might be to put two text controls at the top of the form,
and requery the form's records based on the values in those two fields.
 
Try putting this in the critera part of a query in a date
field. It will prompt the user for a beginning date and
an ending date:

Is Not Null And >=[Input Beginning Date] And <=[Input
Ending Date]
 
Deepak

Open a form in design mode. Add two text controls. Label them
appropriately.

In the AfterUpdate event of both controls, add procedures that:
1. confirm that two dates have been entered
2. confirm that Before date comes before the After date
3. requeries the form

Base the data source for the form on a query that refers to the fields on
the form as criteria (see the other response to your post for notions on a
parameterized query).
 
Back
Top