Query help

[gmatriix]

Hello All,

In my query I have "[Which LC?]" to query on a table. How can I set it up to requery if the result are false or it did not find it.

Right now it just takes me to a blank screen that you cannot get out of unless you close the form.

Please help

Thanks

Gmatriix

 

[dcobau]

On the OnOpen event of the form you could do

Dim intTemp as String
intTemp = DCount("[FieldName]","qryName")

If intTemp = 0 then

msgbox "There are no records, form closing....."
docmd.close "frmName"

end if

Dave