using recordset from filtered form- access 2007

Topic

New Reply

If I use the filtering options on a continous form, can I then use the recordsetclone to get only those records and then save them as a table or send them to word or excel, as the basis for a mailmerge? If someone has code for this, great, otherwise I will try to create it.
Thanks

Reply | Quote

Replies

You could use code like this:

Code:

Dim strSQL As String
If Me.FilterOn = True Then
  strSQL = "SELECT * INTO tblNew FROM tblOld WHERE " & Me.Filter
  CurrentDb.Execute strSQL
End If

Here, tblNew is the name of the table to be created, and tblOld is the name of the table (or query) that acts as record source for the form.

In the above, I assumed that the code is in the form’s own module. If it’s not, you must replace both occurrences of Me with a reference to the form, e.g. Forms!frmTest.

Reply | Quote

Brilliant. A lot easier than reacordset clone.
Thanks as usual

Reply | Quote