Combo box dropdown problem

[Andrew W]

Hi All,

I have two combo boxes: Parameter and SensorComponent.

When Parameter is changed, I want SensorComponent to requery &
dropdown.

It does requery & dropdown, but it drops down for only an instant.

Any suggestions or comments would be appreciated!

I'm using the following code:

Private Sub Parameter_Change()

Me.SensorComponent.SetFocus
Me.SensorComponent.Requery
Me.SensorComponent.Dropdown

End Sub

[Rick Brandt]

Andrew W wrote:

Hi All,

I have two combo boxes: Parameter and SensorComponent.

When Parameter is changed, I want SensorComponent to requery &
dropdown.

It does requery & dropdown, but it drops down for only an instant.

Any suggestions or comments would be appreciated!

I'm using the following code:

Private Sub Parameter_Change()

Me.SensorComponent.SetFocus
Me.SensorComponent.Requery
Me.SensorComponent.Dropdown

End Sub

I just tested this and it worked fine for me (although I would probably use
AfterUpdate instead of OnChange).

Do you have any code in the GotFocus or Enter events of SensorComponent?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Andrew W]

Rick,

I don't have any code related to other SensorComponent events.

I think the problem is the rowsource query for SensorComponent, which
depends on three combo boxes including Parameter.

I'm rebuilding the form with a subform to handle these data.

Thanks for your help.

Andrew