 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / October 2005Continuous Forms - Event Fire on Each Record?
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. Use the On Current event.  SignatureDuane Hookom MS Access MVP >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. Use the form's Current event. SignatureKen Snell <MS ACCESS MVP> >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. 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. SignatureDuane Hookom MS Access MVP >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. 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. 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. You could use a domain aggregate function such as DMax(). The form might be slow to load and display. SignatureDuane Hookom MS Access MVP > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.