I'm using the following code in the Click Event of a list box in one form to
open another form and go to a specific record:
stDocName = "frmActivity"
stLinkCriteria = "[ProjectID]=" & Me!List2
DoCmd.OpenForm stDocName, , , stLinkCriteria
The problem with this operation is that it does more than simply go to a
specific record - it also filters the recordset to display only that record.
How can I modify that code so that it selects the desired record in the
form, without filtering the recordset so that all of the records are
available in the form?
Thanks in advance,