Field based on query in report

[thart21]

I have a form w/a subform based on a table which shows individual employee training records, In the subform, there is a column "Hours". Each ee must have 40 hours a year in training. I am trying to just place a text box in the main form which will show the user what their current running total is for this year. I have created a query "qryHours" and have used that as the control source for my text box "TotalHours", and also tried to put it in the subform, referencing that text box in the main form. Nothing seems to work. It sounds like it should be simple, though.

Any ideas would be appreciated!

Thanks,

Toni

 

[GumbyD]

Toni -

How are you getting the data? Are you using a dlookup or pulling the field directly from the underlying query? I have done similiar stuff to what you are doing and I used code. I created a function that ran after any updates to the data in the subform and then set the value to the field on the main form based on the results of the code.

GumbyD