Parameter Query problem (1 Viewer)

ColMac

New member
Local time
Today, 10:01
Joined
Sep 26, 2019
Messages
7
Hi, I'm a newbie with Access.

I have a query where I have a Parameter to request surname, followed by a second one to request a first name. I would like the second one to offer an alternative of all possible first names. Is this simple to do?

access.jpg

Thanks
 

namliam

The Mailman - AWF VIP
Local time
Today, 11:01
Joined
Aug 11, 2003
Messages
11,519
No its not simple to do, not crazy difficult neither if you know how.

What you want is a search form and/or a cascading combobox... have a look around and see how far you get with that come back with any and all questions you have.
 

ColMac

New member
Local time
Today, 10:01
Joined
Sep 26, 2019
Messages
7
Thanks, I'm trying now. I'll update later
 

theDBguy

I’m here to help
Local time
Today, 02:01
Joined
Oct 29, 2018
Messages
8,713
Hi. When you say "alternative first names," are you saying a limited list based on the last name entered by the user? Just curious...
 

ColMac

New member
Local time
Today, 10:01
Joined
Sep 26, 2019
Messages
7
Sorry I didn't make it clear enough.

The list contains many people with the same surname. The list also contains many people with the same first name.

I want the ability to produce a list with for example everyone with a specific surname eg "Smith" or alternatively everyone with a specific surname eg "Jones" and a specific first name eg "Robert". Smith (or Jones) & Robert both to be selected by the user.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom