AC97: Would like to make 1 control dependent on another.

[KelMcc]

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.

Thanks.

 

[vangogh228]

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.

 

[KelMcc]

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.

 

[KelMcc]

Got it! Thanks