Access 97 and Recordsetclone

[Ian Bailey]

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

[Trevor Best]

Ian Bailey wrote:

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

DoEvents after setting form's bookmark perhaps?
--

\\\\\\
\\ \\ Windows is searching
\ \ For your sig.
\ \ Please Wait.
\__\

[Dutchy]

forms("yourform name").recalc perhaps ?

--
Dutchy
Ian Bailey <im******@hotma il.com> schreef in berichtnieuws
2c************* *************@p osting.google.c om...

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

[Ian Bailey]

Thx for suggestions but neither of them worked. I also tried a
requery on the form. In the end I got it working by closing the first
form, re-opening it and then positioning on the required record - this
had the effect of updating the controls immediately. I don't
understand why it doesn't work if the form is not closed first.

Ian

im******@hotmai l.com (Ian Bailey) wrote in message news:<2c******* *************** ****@posting.go ogle.com>...

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