472,102 Members | 1,070 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,102 software developers and data experts.

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

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 Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.