Enable button only when there is at least 1 record

S

scubadiver

I want to keep a record entry button disabled only until a record is entered
in the subform and then keep it permanently enabled.

thanks
 
D

Daniel

Use the subform's oncurrent event and do a recordcount. if recordcount>0
then enable the control on the main form else disable.
 
S

scubadiver

I inserted the following into a text box in the subform and named the
control "RecCount"

=RecordsetClone.RecordCount

This works fine but now I am not entirely sure what to put in the
"oncurrent" event. I am not sure how to reference the button in the code..
 
Top