Avoid reentering parameters using Requery? 1

[MontgomeryPete]

We have a form that must be refreshed frequently by the user. When requery is used it prompts the input of the parameter to get the result set (new reservatins). Does anyone know of a way to keep the current date at requery time?

Thanks in advance.

 

[dhookom]

Use controls on a form to provide criteria values for queries. If you don't close the form, your values will persist.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]