[AccessD] filtering a subform

I need to use a SQL statement. 

Susan H. 

On 22 Sep 2005 at 9:40, Charlotte Foust wrote:


The following code switches display between the two recordsources in the
subform every time I click on the button on Form2

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