Maximize form if query returns value

[Brigham Siton]

Hello all,

I have a form based on a query. Sometime, the query will have data in there
and sometime, it will not have any data.

Is there a way to control the form so it will only open or maximize if the
query has data in it? Or if you have a better solution, let me know.

Thank you very much in advance.

 

[Brigham Siton]

Thank you very much.

Dim StrData As String
StrData = <field name here>

If StrData = "" Then
Exit Sub
Else
'Your maximize code
End If

--
Regards

Steven Burn
Ur I.T. Mate Group CEO
www.it-mate.co.uk