Recent content by Lenford

Perhaps try: If Me.txtType = "D" Then Me.dbo_OSAddress_subformD.Visible = True Me.dbo_OSAddress_subformO.Visible = False Else If Me.txtType = "O" Then Me.dbo_OSAddress_subformO.Visible = True Me.dbo_OSAddress_subformD.Visible = False End If

Hi, Have been playing with this for 2 days and unable to get it to work properly. Any help is greatly appreciated. I'm using Access 2003 (with an upgrade to Access 2010 in the near future.) My objective is to have a subform that displays a datasheet based on a query that changes - the query...