Need begining and ending date

[teiben]

I have a report "enter job number", which has a textbox with
="Covers Dock Audits from " & [Forms]![TimeFrame]![tBeginDate] & " to " & [Forms]![TimeFrame]![tEndDate]

which works great if the user bothers to go to the calendar, TimeFrame, and select the tBeginDate and tEndDate. How would I go about setting some kind of default? I'm getting fustrated with this whole thing

 

[ColinEssex]

Presumably the users have to click a button to run the report.

Why not have the calendarForm open when the button is clicked? then run the report after they've selected the dates, the calendar form could be minimised.


Col

 

[teiben]

I already tried that, having a calendar run, pick a date, and have the switchboard open. WHen I select the report, I get the same error.

 

[EileenL]

Is there a standard date range that is normally pulled?

If there is a standard date range that is normally pulled why don't you set the default start and end dates based on the current date. For instance I pull a report for policy expirations normally 90 days in advance so I set the default start date to the current date and then set the end date to = 90 days after the start date.

Hope this helps.

 

[teiben]

& how do you set a standard date range, in the report;
I've tried

Dim tBeginDate as string
Dim TtEndDate as string

On form open
Me!tBeginDate = DateAdd("d", -30, Date)
Me!tEndDate = DateAdd("d", 1, Date)

end sub