VBA code to select data from table into combobox

[Gerry Bennett]

I have data stored in a table, Surname, firstname, date of birth. What I
want to do is select the surname in the combobox I have done this part. I
then want to select the firstname from the associated data in the table, ie
three people sharing the same surname but different first names, so that
only those three names show not all the names I have in the list. this
should then be down to one name and the date of birth then populates the
third box. Can anyone help me out with this.

 

[Dick Kusleika]

Gerry

You can do this with ActiveX controls and event macros. I posted some
screen shots here

http://www.dicks-blog.com/archives/2005/05/27/single-list-combobox-filtering/

Let me know if that's not what you're looking for.