Stepping through records on a SubForm

[wyoung71]

Hey All,
I'm needing some help with a form in Access 2000. I have a form that has a subform. The subform is set to a query and takes parameters from the parent form. The problem I'm having is I need to access each record from the query on the subform as it is written to the form. I'm looking for a property similar to the report property Details OnFormat. That property allows you to see each record as it is written to the report. I'm looking for something simliar for the forms Detail.

Any help or point in the right direction would be appreciated.

Bill

 

[PWise]

what are you trying to acomplish?

 

[wyoung71]

I'm trying to populate some unbound Textbox controls in the subform based on the criteria of the records as they are being wirtten in the contiunous SubForm. I have a production Database where pieces are being produced at different locations on different dates. I'm displaying all of the locations producing pieces and the dates for a week. It would be easy if it were 1 piece being produced per location but as fate has it sometimes I have multiple pieces per location on a date and want to display all of the individual pieces.

 

[wyoung71]

OK I solved it! Basically I wrote a Module to handle writing the data to the unbound fields. Problem solved now I just have to work on the speed of the calculation.