Pop Up Date Selection

[Ukraine82]

I made a pop up form for employees selection.

I would like to know is how I can have radio button selected along with date entered and go to that specific report?

Take a look at the attachment.

I have 3 report to choose from, but I would like run report1 from 1/1/05 to 1/10/05.

My Start Date and Enter Date are unbound text boxes.

Thanks,
Michael

 

[trucktime]

Report

Michael, may be this link is helpful.

http://www.microsoft-accesssolutions.co.uk/report_date_parameters.htm

 

[Ukraine82]

Trucktime,

Thanks I appreciated.

Michael

 

[Ukraine82]

I'm having trouble using my start date and end date.

I'm using code on command click to open a report from a combo box (which is working).

If IsNull(Me.Report_Selection) Then
MsgBox "Please Select A Report", , "Form Missing"
Else
DoCmd.OpenReport Me.Report_Selection, acViewPreview
DoCmd.Maximize
End If

I would like the user to enter the start date and end date, select the report, and run it.

Thanks,
Michael

 

[trucktime]

Date

Is your report based on a paremeter query?

If so, in the Criteria of the Date field put something like this:

Between [First Date] And [Last Date]

 

[Ukraine82]

My report is running from a query, but I'm not using any parameters because I would like the user to use a pop up form selection to enter the start date and end date.

hope it not confusing.

Thanks,
Michael

 

[Ukraine82]

Trucktime,

Nevermind I forgot one item in my query.

>=[forms]![FormName]![txtField] And <=[forms]![FormName]![txtField]

Thanks again.

Michael

 

[trucktime]

Report

I'm not sure if this would work but you could give it a try.

In the Criteria of the Date Field put something like this

Between [Forms]![frmReportSelectionMenu]![StartDate] And
[Forms]![frmReportSelectionMenu]![EndDate]

Good Luck