By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,935 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Access 97 and Recordsetclone

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.
\__\

Nov 13 '05 #2

P: n/a
forms("yourformname").recalc perhaps ?

--
Dutchy
Ian Bailey <im******@hotmail.com> schreef in berichtnieuws
2c**************************@posting.google.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

Nov 13 '05 #3

P: n/a
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******@hotmail.com (Ian Bailey) wrote in message news:<2c**************************@posting.google. 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

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.