Search results for query: *

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...

Many thanks to Jeremy & C! This was exactly what I needed and it works flawlessly.

Sorry C, I need more explanation, what is tied to this table? The textbox on the form? And how does it increase value?

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...