Displaying of Date Parameters

L

Lorraine

On a form called SFI Reports I have a textbox called BegDate and another one
called EndDate, both with a Short Date format and =Now() as thier default
values. When a date is placed in both of these textboxes and a Run Report
button is clicked, the query looks at the dates that were entered in the
BegDate and EndDate textboxes and finds records between these two dates.

I would like to have a textbox on the report that auto fills with the dates
that were entered in the BegDate and EndDate texboxes. How do I code this?
 
O

Ofer Cohen

If the form is still open then you can try

="Between " & Forms![SFI]![BegDate] & " And " & Forms![SFI]![EndDate]
 

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