How to get control loading data in subform

[RickCaird]

I am developing a classic order/detail kind of application. The twist is that I need program control to sum the detail records. Based on the year of the transation, I need to put things into different buckets.

What I need is an "On CURRENT" type of event while the form is loading the intiial data. But, I can't seem to find an event that gives me control while populating each line of that data Nor can I see a way to go back and programatically access each data row in the form.

Does anyone have any ideas as to how to access each line in a continuous form? I am kind of looking for a VB6 DataGrid type of control.

Rick

 

[Dreamweaver]

Look in the help files for subform/Continuous Forms The are very much like the VB Grids.

also look in the examples there's loads their all it takes is to look.

Mick
The event your looking for is ONCurrent (Not sure if it fires for each row when the forms loading) but if you use a Query you wont need to use any code.

 

[RickCaird]

On Current does not fire on initial load. My current solution (which I don't really like) is to issue the same query on the main form load and get my own totals from that. Now, I will just have to make sure that I update those totals when a transaction is updated or added.

Rick