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 Subform there are no records in my subform. But if I click to design view and then right back to form view there are all the records that should have been there. WHat the Hell is going on? I don't do anything in design view. Why does it work like that?
The subform is based on a query, if that helps. It's like its not running the query when the form opens but when I click design view and then click form view it works. I need the records to show when it opens.
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 Subform there are no records in my subform. But if I click to design view and then right back to form view there are all the records that should have been there. WHat the Hell is going on? I don't do anything in design view. Why does it work like that?
The subform is based on a query, if that helps. It's like its not running the query when the form opens but when I click design view and then click form view it works. I need the records to show when it opens.