Remembering Entries on a Pop-Up Form

[jalge]

Is there a way for Access to "remember" and automatically fill in entries entered or selected in pop-up form that is used to both set query criteria and then provide text on a finished report?

The pop-up is tied to the "On Open" property of a report, and controlled by a macro using the "IsLoaded" function.

Every time the pop-up form opens, all the fields are blank and need to be filled in again. This can be quite a pain when running the report over and over with virtually the same parameters.

By the way, I "discovered" this forum only the other day. It is fantastic!

 

[AlanS]

One way is to set up a Parameters table with a single record containing the saved values from the form. The form would then be bound to that table and have its NavigationButtons and RecordSelectors properties set to No.

A more elegant way to do this is with user-defined database properties, but that takes a bit more coding.