Dialog Box with dates

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?
 
M

Marshall Barton

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

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top