Requery Parameter Problem

[pyrite]

Hi,

I have found a solution to a problem similar to mine but it was a bit too
technical for me to understand.

Basically I have a split form which displays the results of a query. This
query is based on a criteria entered by the user. The method for the user to
enter this criteria is via an unbound drop down box on another form. I have a
'search' button which then opens the split form with the query taking its
parameter from the result of the drop down. Hope that makes sense.

So I have:

frmQueryParam
qryQuery
frmQueryResult

frmQueryParam contains the drop down, it then opens frmQueryResult with
qryQuery taking its criteria from frmQueryParam.

frmQueryResult basically displays a list of equipment booked out to an
individual (datasheet) with the individuals details (form) coming from one
table and the equipment coming from another (one to many relationship). On
frmQueryResult I then have a button which opens a form to add a new item of
equipment. On this form a button then closes the form when completed giving
focus back to frmQueryResult.

My problem is that the list of equipment on frmQueryResult does not update
and so the new piece of kit isn't listed. I have set up a Me.Requery in the
OnActivate event which does the trick nicely, my problem is that it asks for
the parameter again. I need it to either recall this parameter from the
original entry or alternatively the persons name is listed on the add
equipment form so it could be taken from there.

I hope that makes sense and isn't too long winded. Thanks for any help you
can offer.

 

[M.]

Could you include the code you're currently executing on / between different
forms?

M.