469,928 Members | 1,814 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,928 developers. It's quick & easy.

Select only filtered records

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...

Aug 23 '07 #1
0 1437

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Ian Davies | last post: by
1 post views Thread by Mr. SweatyFinger | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.