Private Sub Form_Current()
If Forms![frmAddNewParts]![frmStockMaintenance].Form.RecordsetClone.RecordCount = 0 Then
'Forms![frmAddNewParts]![frmStockMaintenance].Form.Visible = False
[B]If this is on frmAddNewParts then you don't have to go through the Forms collection.
Change to:
Me!frmStockMaintenance.Visible = False[/B]
Else
'Forms![frmAddNewParts]![frmStockMaintenance].Form.Visible = True
[B]Me!frmStockMaintenance.Visible = True[/B]
End If
If Me.frmStockMaintenance.Form.Recordset.RecordCount = 0 Then
Me.frmStockMaintenance.Visible = False
Else
Me.frmStockMaintenance.Visible = True
End If
I don't see the answer.By the way, do the diagnostic TextBoxes show the RecordCount and the Visible condition?