#Deleted Messing Up Code

M

MBoozer

I can't get the following code to work when I delete a record on one subform
and then go back and look at a linked subform (MDSDDocsTabSubform).

If (Me.RecordsetClone.RecordCount = 0) Then
Forms![ChemicalInventory].[MSDSDocsTabSubform].Form!NotAvail.Visible = True
Forms.ChemicalInventory.MSDSDocsTabSubform.Requery
End If

All the fields on the record in MSDSDocsSubform properly show #Deleted but I
want the NotAvail icon to be visible. Any ideas? This works if there is only
1 record on the MSDSDocsTab Subform but if there are two or more it does not.
Need syntax for doing the above if there exists 2 or more records?
 
Top