IF statement for more than 1 record

[robsworld78]

Hi, I want to make an IF statement that says the following

If Me.OrdersOrdersSubform.Form.RecordSet = more than 1 record Then
     Do something
Else
     Do something else
End If

Thanks

 

[jzwp22]

You could use a DCount() on the same record source as the subform. I assume that you would want to filter based on the orderID of the main form. The me.orderID might change depending on what event and from where the event is triggered.


IF DCount("*","tableorqueryname","orderID=" & me.orderID)>1 THEN

ELSE

END IF

 

[Beetle]

Use the .RecordCount property

If Me.OrdersOrdersSubform.Form.RecordSet.RecordCount > 1 Then
     Do something
Else
     Do something else
End If

 

[robsworld78]

Thank-you the .recordcount works great