Combo Box CRAZED! 1

[srossbach]

What I have are two tables with the following fields:

Units:
Unit (number)
Description (text)

Chapters:
Unit (number)
Chapter (number)
Description (text)

Both of these tables already contain values.

I have created a Form "Member Information" and have two combo boxes cboUnits and cboChapters. The second cboChapters is supposed to provide only the Chapters that coincide with the Unit number provided in cboUnits . Seems to work great until I move to the next record - and the cboUnits - doesn't seem to reset itself.

??????????????

I have struggled with the way to long with the same results - any help would be appreciated!

Thanks.

 

[spikebears]

Try using the Me.Recalc upon the After Update event for your cboUnit Combo Box.

Private Sub cboUnit_AfterUpdate()
Me.Recalc
End Sub

 

[srossbach]

No - now it can't find "Me"

It works fine on the first record and then won't reset when you move on to the next. Keeps the same values.

 

[Nowell]

Hey I just had this problem and your solution works very well spikebears

 

[spikebears]

srossbach,

Did you get any error message? if yes, then what it says? "Me" is a reserve word for current form, Me.Recalc means putting a command to recalculate every field in the current form.

Spikebears