:) wrote:
I'm trying to make a form with two subforms, each one has a list but I
only want the second form to show when it contains data, I know this is
possible as I've seen it done, anyone know how?
Here is an example of turning on/off the visible property as I move from
record to record.
Private Sub Form_Current()
Dim rst As Recordset
Set rst = Me.RecordsetClone
rst.Bookmark = Me.Bookmark
Me.Customer_Orders_Subform1.Form.Visible = _
(rst.AbsolutePosition Mod 2 = 1)
rst.Close
Set rst = Nothing
End Sub
THe syntax is Forms!MainForm!SubForm.Form.Visible