M
MikeS
I recently created a form which consisted of simply a couple of labels, one
"Refresh" button and the three subforms. The 3 subforms display hour by hour
data of number of units produced. To populate the subforms, I use a query
that displays line number, date, and an expression that extracts the hour
from the date field (DatePart). A second query summarizes the first query to
show units produced per hour. This form worked fine yesterday, however,
today when I opened it, it was completely blank. When I switched to design
view, everything was there. The only thing that might be a clue is the fact
that one of the subforms did not have any data to display. It wasn't until
that line/subform had a record to display that the form returned to normal.
Can anyone explain why this happened?
Thanks in advance,
Mike
"Refresh" button and the three subforms. The 3 subforms display hour by hour
data of number of units produced. To populate the subforms, I use a query
that displays line number, date, and an expression that extracts the hour
from the date field (DatePart). A second query summarizes the first query to
show units produced per hour. This form worked fine yesterday, however,
today when I opened it, it was completely blank. When I switched to design
view, everything was there. The only thing that might be a clue is the fact
that one of the subforms did not have any data to display. It wasn't until
that line/subform had a record to display that the form returned to normal.
Can anyone explain why this happened?
Thanks in advance,
Mike