I'm making my first DB in Access 97 and have this stumbling block (among many!):

I have to combo boxes. They read records from table 'project' and the form writes to table 'ISIF'. When the user selects one of the choices of the 1st combo box, I would like the 2nd combo box (I guess this could really just be a label?) to autopopulate with the corresponding match.

So, the first combo box is "02projects" and they select 0001. I'd like the 2nd box, "projectname" to autopopulate w/ the name that corresponds. Both of these data items are in the 'projects' table and have a 1-to-1 relationship.

I'm just getting my feet wet w/ Access, so dumb down your answers as much as your patience allows. http://www.access-programmers.co.uk/ubb/smile.gif

Thanks.

Kel:

This question gets asked on here pretty often. Do a search of the archives for "cascading combo boxes" and you should find more than enough info.

OK, I've got some stuff to work w/ from some of the old posts. I'll let you know if I can get this to work. http://www.access-programmers.co.uk/ubb/smile.gif

Got it! Thanks