[AccessD] filtering a subform

I tried the RecordSource property yesterday and got an error -- I'll try
again today, maybe I just typed something wrong. 

Susan H. 

This works exactly the same as the first example:

Private Sub Command9_Click()
If Forms!form2!Form1.Form.RecordSource = "SELECT Table1.* FROM Table1; " 
Then
 Forms!form2!Form1.Form.RecordSource = "SELECT Table2.* FROM Table2; "
Else
  Forms!form2!Form1.Form.RecordSource = "SELECT Table1.* FROM Table1; "
End If
 End Sub