Detect if subform has records

  • Thread starter Thread starter SF
  • Start date Start date
S

SF

Hi,

I have a main and subform, the main form is use to list individual
organization names where as the subform is used to list questionaire for
that particular organization. The content of the subform is identical for
all main records except the FK. On the main form, I added a button to run
append query to append questionaire, sometime user click the button twice
that add two set of the same questions. Is there a way to check if subform
has record before adding a new set?

SF
 
Test the RecordCount of the RecordsetClone of the Form in the Subform
control:

If Me.[Sub1].Form.RecordsetClone.RecordCount > 0 Then
 
Back
Top