Resetting ComboBox on Form

[nclsgna via AccessMonster.com]

I have a form with two combo boxes ([NmF] and [NmL]) and a calculated text
box ([NmFL]) that is a concatenated value of [NmL] & [NmF]. [NmL] is limited
to a query with [NmF] value as criteria.

I have a command box to reset the values in [NmF] and [NmL] if the user
decides to change the two. Code to reset is:

Private Sub Command24_Click()
NmF.Value = Null
NmL.Value = Null
End Sub

Complication:
If I run Command24_Click(), the [NmL] box retains the last value list from
the previously entered [NmF] value.

Is there a way of making the box requery after resetting so that i get
current values?

 

[magmike]

Did you try a refresh command on LostFocus?

 

[Marshall Barton]

I have a form with two combo boxes ([NmF] and [NmL]) and a calculated text
box ([NmFL]) that is a concatenated value of [NmL] & [NmF]. [NmL] is limited
to a query with [NmF] value as criteria.

I have a command box to reset the values in [NmF] and [NmL] if the user
decides to change the two. Code to reset is:

Private Sub Command24_Click()
NmF.Value = Null
NmL.Value = Null
End Sub

Complication:
If I run Command24_Click(), the [NmL] box retains the last value list from
the previously entered [NmF] value.

Is there a way of making the box requery after resetting so that i get
current values?

The NmF combo box's AfterUpdate event need to Requery the
NmL combo box:
Me.NmL.Requery
You will want to use the same line of code in the form's
Current event and in your button's Click event.

 

[nclsgna via AccessMonster.com]

Thanks guys, I have done as you suggested and its working perfectly.

I have a form with two combo boxes ([NmF] and [NmL]) and a calculated text
box ([NmFL]) that is a concatenated value of [NmL] & [NmF]. [NmL] is limited

[quoted text clipped - 14 lines]

Is there a way of making the box requery after resetting so that i get
current values?

The NmF combo box's AfterUpdate event need to Requery the
NmL combo box:
Me.NmL.Requery
You will want to use the same line of code in the form's
Current event and in your button's Click event.