visible a cmd button if subform show any record

[raton]

a search form with a subform
if subform got a record by the search then a cmd button will me visible
how can i do it

[June7]

In the event that does the search, something like:

If Not IsNull(Me.subformname!fieldname) Then Me.commandbuttonname.Visible = True

or

Me.commandbuttonname.Visible = Not IsNull(Me.subformname!fieldname)

[raton]

this code is not working

problem
a main unboubd form with a subform(subform is made by a query. query has 5 field, namefield criteria is forms!mainform!textboxname )
a unbound textbox in the main form and a search button.
type a name in the textbox and click the search button
which requery the subform and show the result

[June7]

What isn't working - the search or setting visibility? What happens - error message, wrong results, nothing?

[raton]

Private Sub cmdgo_Click()
Me.Qservice_subform.Requery
If Not IsNull(Me.Qservice_subform!Cname) Then
Me.cmdpay.Visible = True
Else
Me.cmdpay.Visible = False
End If
End Sub

visibility is working but the else condition is not working, i want it invisible if the condition is not met

[June7]

Step debug. What happens when you expect the referenced field is null? Does the False line get executed?