Connecting Tech Pros Worldwide Help | Site Map

Select only filtered records

  #1  
Old August 23rd, 2007, 03:45 PM
Ironr4ge
Guest
 
Posts: n/a
Hi everyone,

By the rate its going it want be long till I start growing gray
hair... but anyway..
to come to the point...

I am trying to open the form "Languages" with a diffrent record source
to the "Contacts" form where I conducted the search or filter... .
I was wondering whether there was a simple vba code to select
ONLY ALL FILTERED records of my first form or the "Contacts"
and open this filtered set of records in my "Languages" form.

Subsequently the idea would be to filter those records with the
selected languages.

At the moment I have been using unbound checkboxes with hiden
functions on the background to select each individual contact to be
stored as boolean. The selected records could then be opened in the
"language" form without any problem....

obviously this is a problem when there is over 100 contacts to select
from...


I am not... interested in using sub_forms.. for the simple fact you
cannot view records in a continous mode..

I am just looking for a solution iether by selecting all the
checkboxes of each filtered contact as boolean or by connecting i.e
all ID_contact(s) of one filtered form to another filtered form..


I hope I am not asking too much...

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selectinhg only filtered records (boolean?) Ironr4ge answers 4 August 29th, 2007 02:55 PM
Report the current filtered records from a Form melnhed answers 3 November 1st, 2006 10:55 PM
SQL SELECT query on DataSet(not fill) Mrozu answers 1 November 21st, 2005 11:40 PM
How to "Select All" in filtered recordset GSteven answers 6 November 13th, 2005 11:39 AM