Date Range Problem

[kevin0862]

How do I use VBA or a macro to present either a pop up form or input boxes to accept and validate the dates, then call the queries using the dates entered as parameters? The dates are popping up for both the query and my event. How can I sync both to work together? I current have the query criteria as:

>=[Forms]![Form Date Range]![Beginning Entry Date] And <=[Forms]![Form Date Range]![Ending Entry Date]

Here's my event code...

Private Sub Form_Open(Cancel As Integer)

DoCmd.OpenForm "Form Date Range", , , , , acDialog, "Duplicates in Associates Productivity"

End Sub

Private Sub Form_Close()

DoCmd.Close acForm, "Form Date Range"

End Sub


Can anyone help... Please!

THANK YOU EVERYONE ONCE AGAIN FOR NO ASSISTANCE... I'VE FIGURED IT OUT BY MYSELF!