Combo Box synchronization between main form and subform?

[giaruso]

I have a main form with a subform. On my main form, I have a combo box set to "find a record on my subform, based on what I select in the combo box." This works great! At the same time, I want to use this main form combo box to synchronize with a combo box in the subform to display a value based upon the value selected in the main form's combo box. I have tried several things and searched Access newsgroups without success. I am using MS Access 2002, producing an Access 2000 database. Has anyone got any ideas? I could really use some help. Thank-You.

Denny G.

 

[mresann]

I'm not exactly clear what you want. I understand you have a combo box on the main form, call it ComboBoxA. You want to open up a subform. Once the user picks a record on the subform, you want a value to appear in a combobox on the main form. The question is: is it ComboBoxA, or another combobox?

 

[giaruso]

Thanks. I want to synchronize Combo Box A (on the main form) with Combo Box B (on the Subform). In this case, Combo Box B is dependant on selection made in Combo Box A. All this AFTER Combo Box A has selected a specific RECORD in the subform.

Denny G

 

[andyski101]

I don't know if this is really what your looking for, but what I usally do is lock Combo Box A after a selection has been made and create a command button that has to be clicked if the user wants to change the selection. Its a bit ugly but it gets the job done.

 

[giaruso]

Thanks Andy, I'll give it some thought.

Denny G.

 

[andyski101]

You got me thinking about finding a cleaner way to do this, and I think I found one.

Give the On Change event a try.