Access 2003 - Need help with synchronized combo boxes in subform with continuous view
Posted on 2009-03-29
My Database: I have a simple database with two tables, Questions and Correspondence, that are in a many-to-many relationship. Each Question is assigned a unique CategoryID
Form: I have a Correspondence Form that includes a subform for each Corresp_ID displaying all the Questions asked by that Corresp_ID. When the user enters new Corresp_ID records in this form, they can also enter the questions asked by this new Corresp_ID in the subform using the cboQuestion combo box.
My Question: I would like to modify this subform to allow the user to select a Category in a new cboCategory combo box. This combo box will be synchronized to the Question combo box, so that once a Category is selected, only those questions assigned will appear in the Question combo box.
Also, I would like the subform to be in continuous form view, so that the user can easily see all the questions asked by a particular Corresp_ID. I am having problems with this. Once I go to another record in the subform, the Question combo box in other records either blanks out, or all the records change to the combo box selections made.
I would really really appreciate your expert advice. I have been hitting the wall on this one for quite some time now.
Thanks in advance!