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

The form goes blank if:
a) there is no record to be added, and
b) no new record can be added.

More details in:
Why does my form go completely blank?
at:
http://allenbrowne.com/casu-20.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MikeS" <(E-Mail Removed)> wrote in message
newsAD71B65-5909-4C2D-AAF4-(E-Mail Removed)...
>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.