Requery a parameter query

  • Thread starter Thread starter DW
  • Start date Start date
D

DW

I have a main form with a parameter query as the recordset. There is a
worksheet embedded on the main form as a subform. The data in the worksheet
(subform), upon running an update, alters the data of the underlying table,
from the underlying query, of the main form. Basically, the worksheet updates
the data on the main form.

When the user initially opens the main form, parameters are entered. I would
like to be able to update the data, while retaining the parameters that were
entered when the form was opened. I don't want the user to have to enter the
parameters again every time an update is made. In other words, I want to have
occassions where I can requery a parameter query, retain the previous
parameters and thereby not enter the parameters during the requery. How can I
accomplish this?
 
Depending on how long you want to retain those values:

If only for the duration the user has the file open you write them to
variables.
Else to remember them after the file is closed you have to write them to
table or file.
 
Back
Top