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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

First Subform record gets modified when closing form 3
Unremovable horizontal scroll bar on subform 1
Using an append query in a subform 1
Saving a record in subform 5
Subform with no records 8
Trouble associating parent form record to subform's record 1
Cannot add records to subform 2
Confusion with forms and related subforms 3

Back
Top