Cascading Combo Box

[jschlapi]

Help - I'm getting a bit goofy with this.

My form: has 4 cascading combo boxes - they work perfectly.

1st combo box updates my main table just fine - my #2 box (which is dependent upon 1st combo box choice) does not feed to my main table. After reading several threads, I think I want something in the AFTER UPDATE of box #2, but I'm not sure what it is.

FORM NAME: WORK ORDER FORM
TABLE NAME: WORK ORDER MAIN TABLE
COMBO BOX 1 NAME: EQUIP NUMBER
COMBO BOX 2 NAME: EQUIP NAME (fills in correctly as soon as BOX 1 is done)

Does anyone have a suggestion of how I can get my BOX 2 to populate my WORK ORDER MAIN TABLE?

Thank you so much for reading this & any suggestions/ideas!!

 

[Norie]

What's the rowsource a d controlsource for each combobox?

 

[jschlapi]

row source = EQUIPMENT NUMBER (I hope this is what you mean)

 

[Norie]

All 4 comboboxes have the same rowsource?

 

[jschlapi]

yes they do

 

[Norie]

How does the cascading work then?

 

[jschlapi]

Box 1 is not cascading - I chose an Equipment Number; from there, combo boxes 2, 3 & 4 populate with EQUIPMENT NAME, OIL TYPE, QTY.

Every entry in my form will populate my WORK ORDER MAIN TABLE. I do not need Oil Type or Qty in my Main Table - only EQUIPMENT NUMBER and EQUIPMENT NAME. Equipment Number populates the main table because I specified that when I built that combo box. However, in the cascading boxes, it did not give me that choice.

So, in reading the different threads, I think I need something in AFTER UPDATE - does that sound right?

 

[SydneyGeek]

If all four combos have the same rowsource you're making extra work for yourself.
You could instead use one combo and three texboxes. Bind the first one to the Equipment Name field. Leave the ohter two unbound. Then, in the AfterUpdate event for the combo, put this code:

Me.[EQUIPMENT NAME]=Me.MyCombo.Column(1)
Me.TextBox2=Me.MyCombo.Column(2)
Me.TextBox3=Me.MyCombo.Column(3)

Adjust the names of the controls to match; if there are spaces in the names, enclose them in square brackets.

Combo and listbox column numbering starts at 0 so 1,2,3 are columns 2,3,4 from the rowsource query.

Denis

 

[jschlapi]

If I do this, do you think EQUIPMENT NAME will be able to feed to my WORK ORDER MAIN TABLE in the Equipment Name field?

 

[SydneyGeek]

yes, that's what a bound field does.

Denis