- Joined
- Sep 17, 2012
- Messages
- 1
- Reaction score
- 0
Hi all, i'm new to this forum and also very new to Access 2010. Worked (very) briefly on Access97 some 10 years ago, so i'm very very rusty. I was wondering if someone could give some advice with the problem below.
I've been asked to create a search Userform to all a user to search through numerous (40+) tables of client information. For some of the fields which the user can search, i've been asked to use a dropdown box which will be populated with the possible criteria for that field. All 40+ tables have the same columns but i'm struggling to find a way populate the dropdown box with only the unique fields from across all the tables !!!
Can anyone give me some advice please ??
Cheers,
Busby
I've been asked to create a search Userform to all a user to search through numerous (40+) tables of client information. For some of the fields which the user can search, i've been asked to use a dropdown box which will be populated with the possible criteria for that field. All 40+ tables have the same columns but i'm struggling to find a way populate the dropdown box with only the unique fields from across all the tables !!!
Can anyone give me some advice please ??
Cheers,
Busby