Thanks for the response. Tried your example. Only I need the counter for the error code footer to start over at 1 each time there is a new carton. Then I could apply your example.
I have a report that has 3 grouping levels:
1- Carton #
2- Employee #
3- Error Code
For each carton there can be multilple employees that made errors and multiple errors (separate error codes) for each employee. Sometimes it is just one empl with one error code.
Well in the footer of the Error...
Trying to requery. Checked help, it said when focus goes to subform hit 'shift f9' and this performs a requery, and that works, but I need it to show like that when the form and subform open. Where shoudl I put requery code?
OK I have a main form with a subform on it. These are both only for data entry use.
There is a "print notice" button on the subform that opens another form with a subform on it. This subform shows all Mistakes entered for an employee on a given day. WHen I open this Form and...
I have a report that I need a sequential number printed at the top. Like an invoice number. I can't use an autonumber in a field in the table because I don't need the number based on records. It doesn't matter how many records or pages the report includes, I need the number to increase by one...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.