Cascading combos

[amanke]

I am new at programming in Access and I am writing a database for our church. I have 2 tables, one called “Donators” and the other “Donations”. In the Donators table I have their Last Name and First Name along with their address etc. In the Donations form I use a combo for the Last Name and a separate combo for the First Name. I did this so the person entering data doesn’t have to use a mouse but simply tab and type. Both combos are bound to the ID number. Without using a cascading combo, all First Names appear not just the ones relating to the Last Name. I checked the examples on cascading combos and tried them but without success. I could really use someone’s help. Thanks.

 

[ansentry]

I don't think that you need 2 combo's. you can combine the last and first name in a query (see attached sample).

You don't say what you are doing with the LastName FirstName after it has been selected.

In my sample when the user selects a first and last name the combo fines the record for that customer. The names are only a guide for the user as the record is "found" by the PK (DataID).

If my example does not assist you then post back and explain what you want to do with the first and last name after they have been selected.

 

[amanke]

A little more info

John,
Thanks for your help but I included the database to show a little more what I am trying to do. They would like to enter the data by either name or ID number and they want to avoid using the mouse as much as possible otherwise they could simply select the name from the first combo.
Thanks again.
Art

 

[Robert88]

Hi amanke,

Not sure if these notes will help;

http://www.fontstuff.com/access/acctut10.htm

Good Luck

Robert88