Access 2003 form & combo boxes / sync 2

[swtrader]

Am puzzled. I can't get an errorless sync between combo boxes on the same record.
tblManufacturers has a 1-to-M relationship with tblModels.
say, ABC Manufacturing has 3 models: red, blue, and green
XYZ Manufacturing has 3 models: XYZ1, XYZ2, XYZ3
DD Manufacturing has 3 models: DD1, DD2, DD3

So, I have a subform for the MainOrderForm. The subform has 2 combo boxes: cboManufacturer and cboModel. I have attempted to run a requery on cboModel in varying ways including running Me.cboModel.Requery on the AfterUpdate Event in the cboManufacturer combo box. If I have successfully entered the first record on the subform (say ABC/red) and I enter a 2nd record, selecting DD, the Requery runs but cboModel on the first record re-sets to Null. I had Me.cboModel = Null as a line of code before the Requery but I've commented it out.

????

 

[dhookom]

What are the row sources of the combo boxes?

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

How are ya swtrader . . .

If my read is correct your having a common problem with bound comboboxes on a continuous subform. Realize that each combobox of each record is not a seperate entity/object, and that they all share the same Row Source! So when criteria filters for red, blue and green, how could the combobox possibly show XYZ1, XYZ2, XYZ3?

Also see The Evils of Lookup Fields in Tables

Your Thoughts? ...

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[swtrader]

You've both given me some direction. I've slept a couple of years since I built a database with continuous subforms -- so thanks for reminding me about the limitation on CF's combos. I've read online that a - perhaps not the only nor the best -- solution is to lay a textbox on top of the combo box. Would you both recommend this approach or can I skin it some other way?

 

[dhookom]

The textbox option is fairly popular. I have also, used a solution where all of the options are available but the undesirable options/items are at the very bottom of the dropdown list.

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

swtrader . . .

Agree with dhookom . . .


See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]