Hi There,
I have a main form that with a subform which is based on a parameter
query. I have 2 controls on the main form [OpenDate] & [Close Date]
which are used as parameters in the query. It all works fine and dandy
until the query returns no records. The main form just "whites out"
(probably due to the background coulor set to white!) when I get no
records. I have coded and error message in the subform for when no
records are returned and that doesn't show up either. It does however
work if the subform is opened independently. I have tried coding the
main form with the error message but again the white out prevails.
All I want if i get no records is that an error message pops up and
stes the foucs to the date controls.
Can anyone tell me what is going on please.
Cheers,
John