Open a form with a filter.

[adz2013]

I have been trying this for a while now and I am still having problems. I have done this before but for some reason it is not working. I have a form that if the user clicks on view it will show previous data. If the user clicks new then they enter a new record. The problem I am having is I can not get the form to open and filter out the data for viewing. I just want the user to see the data for a paticular date. I have a form that opens with a list of dates and then there is a submit button which opens the form with the data.

Any ideas?

 

[RichO]

You simply need to specify your criteria in the Open Form command line, ie:

DoCmd.OpenForm "MyForm", , , "[DateField] = #" & Me.SelectedDate & "#"

 

[adz2013]

RichO,

Thanks!