Enter Parameter Value Query

[RigoraNocels]

Hi,
I am creating a database to run maintenance checks on the equipment we have installed and I have a query that is filtered by a date specified by the user, obviously this creates a parameter value dialog box which is fine.

However when I move to the form and open it asks for the date twice.



I have a macro which runs an append query creating rows in another table when the form is updated. I have it against the After Update event. This query also has a filter on the date... is this likely to be causing the second parameter value dialog box? If so, is there a way I can get around this?

I am running Access 2007.

Many thanks

[CJ_London]

normally when opening a form, you have the form provide the parameters - either on opening as a parameter of the docmd.openform method or as an unbound textbox on a form to apply a filter or requery the form once opened.

[ranman256]

you can do away with the param query and the macro.
on a continuous form that shows all records, user enters a date, and it filters the records.:

sub txtBox_Afterupdate()
If IsNull(txtBox) Then
  Me.FilterOn = False
Else
  Me.Filter = "[MyDate]=#" & txtBox & "#"
  Me.FilterOn = True
End If
end sub