I have developed a routine that opens a number of forms with each form
being positioned on a particular record. I am using the
Recordsetclone to find the record and then setting the form bookmark
to the recordsetclone bookmark.
The first form is already open and so is just positioned to the
desired record. The second and subsequent forms have underlying
queries that filter using a value from one of the controls on the
first form.
My problem is that, although the recordsetclone and bookmarking is
working, the controls on the first form do not appear to be updated
until the code has finished executing. When the second and subsequent
forms open, the underlying queries use the original value from the
control and not the value from the bookmarked record. Only when the
code has finished executing do the controls on the first form reflect
the bookmarked record.
Any ideas why this should be and how to get around it?
Thx
Ian