Parameter Query problem

[ColMac]

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?



Thanks

 

[namliam]

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]

Thanks, I'm trying now. I'll update later

 

[theDBguy]

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]

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.