F
Fred Parkinson
I am using AccessXP as a front end to a postgres database.
For some reason, a line in VB:
recordsetclone.findfirst "registration_id = " & cstr(id)
frequently fails to execute, even though the line is in
the execution path of my code!
Context:
A user can look up a students enrollment history on one
form, then select an enrollment record and click
a 'details' button. The history form passes the
registration id to the detail form by way of setting a
public property. In the property let code of the detail
form, I execute the above recordsetclone line to locate
the enrollment record and then force the detail form to
show the requested enrollment details. Frequently the
detail form never changes from the last viewed details.
When I step through the code in debug,
the 'recordsetclone findfirst' line is hilighted, but
when i click the 'execute line' button on the debugger
menubar, the system immediately jumps to the following
line without actually executing the recordsetclone line!
This leaves the detail form at the last viewed details,
not going to the new requested record!
Is this a bug in Access? Is there any resolution?
Thank you for whatever help you can give.
Fred Parkinson
Association of Bay Area Governments
For some reason, a line in VB:
recordsetclone.findfirst "registration_id = " & cstr(id)
frequently fails to execute, even though the line is in
the execution path of my code!
Context:
A user can look up a students enrollment history on one
form, then select an enrollment record and click
a 'details' button. The history form passes the
registration id to the detail form by way of setting a
public property. In the property let code of the detail
form, I execute the above recordsetclone line to locate
the enrollment record and then force the detail form to
show the requested enrollment details. Frequently the
detail form never changes from the last viewed details.
When I step through the code in debug,
the 'recordsetclone findfirst' line is hilighted, but
when i click the 'execute line' button on the debugger
menubar, the system immediately jumps to the following
line without actually executing the recordsetclone line!
This leaves the detail form at the last viewed details,
not going to the new requested record!
Is this a bug in Access? Is there any resolution?
Thank you for whatever help you can give.
Fred Parkinson
Association of Bay Area Governments