Dialog Box with dates

  • Thread starter Thread starter dcrqueens
  • Start date Start date
D

dcrqueens

I have 3 fields that I use for follow up in my database. I would to create a
report for the user to be able to enter dates via a dialog box using a date
picker. The problem I have is that since it is 3 separate fields how do I go
about doing that? My three fields are:

Initial call
Before delivery
After delivery

Is this possible?
 
dcrqueens said:
I have 3 fields that I use for follow up in my database. I would to create a
report for the user to be able to enter dates via a dialog box using a date
picker. The problem I have is that since it is 3 separate fields how do I go
about doing that? My three fields are:

Initial call
Before delivery
After delivery
Click to expand...

Create a form with your three date pickers. Then you can
open it in dialog mode whenever you want users to enter the
dates.

OTOH, why use a dialog at all? If you use a form with three
date pickers and a button that opens the report, things
would be cleaner and easier. If you want to use the dates
as criteria in the report's record source query, just refer
to them using this kind of syntax:
Forms![name of form].[name of a date picker]
 
Back
Top