On Current Event in Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that displays records from a query. The form is "continuous"
and I have an event procedure written for the "On Current" event, which
should fire when the record changes. I'm manipulating the dynaset columns to
populate unbound controls in the form. However, the event fires on the first
record but not the others. If I switch to a single record form and step
through each record the procedure works fine. How can I get the event to fire
with every record using a continuous form?
 
Are you sure it's not working? Have you put a breakpoint in the procedure?

Unbound controls will have the same value for every row of the continuous
form.
 
Yes, I used a breakpoint to trace the flow. The event fires on the first
record, does what I need it to do to populate the unbound controls, and from
there on ignores the "On Current" event processing. And yes, every row in the
form reflects the contents of the first row, when the event fired and ran the
procedure. So I'm not sure if this is a bug in Access or if I'm overlooking
something.
 
I assume there are bound controls on the form, not just the unbound
controls.

How are you moving from row to row?
 
Yes, bound controls are on the form. At first, I set them to not visible, but
now they're visible so I can compare their contents to the unbound controls.
I'm not doing anything specific to move from row to row. I assumed that as
Access read through the rows from the query dynaset to populate the
continuous form, the On Current event would fire and execute the procedure
that populates the unbound controls. Interestingly, the bound controls are
displaying properly throughout the form. It's just ignoring the On Current
event after the first row.
 
The Current event fires as you move from row to row on the form, not as the
form is populated.
 
Okay then. I'll have to come up with another approach. Thank you very much,
Doug. I greatly appreciate your assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form's Last Event 2
Before ON Current Event 7
How to choose a form record based on selection from a subform? 6
BeforeUpdate not firing 3
Image on a continuous form 3
When does record become dirty? 10
subform oncurrent event 1
Delete events on a Continuous Form sub form 3

Back
Top