Continuous Forms - Event Fire on Each Record?

[jason.gyetko]

I know on reports you can use the Detail_Format to run code against
each individual record, is there a way to do that on a form? Thanks.

 

[Duane Hookom]

Use the On Current event.

 

[Ken Snell [MVP]]

Use the form's Current event.

 

[Duane Hookom]

I should have mentioned that if you change a control's property in the On
Current event of a continuous form, the property changes for all records in
the form.

 

[jason.gyetko]

I noticed that. So is there no way then to run a process for each
record on that form? I can probably accomplish what I need using more
queries for the record source, but it would be easier the other way.
Here's my situation if you can offer any alternatives, I would
appreciate it. Thanks again.

I have a continuous form each record has a milage number reocrded with
a particular license number. I need to take that license number, then
look back in the table at the last record (with the same license
number), and see what the milage was there, then I have to subtract
that milage number from the first milage number and post the result.

 

[Jason Gyetko]

Well, I thought I could do it within my Record Source query, but now
that record source is not updateable. Everything looks ok, all my data
is displayed correctly, but when I go to update it from within my form,
it will not update because of the joins I am using.

 

[Duane Hookom]

You could use a domain aggregate function such as DMax(). The form might be
slow to load and display.