Private sub running before controls update

[mguidry5]

Hey there,

I have a combo box called cboParameter on a form. It's row source has several columns which will display on txt boxes with their control sources set to cboParameter.Column(2) etc...

My problem is this: I have a Private Sub in the form that is called on the afterupdate event of cboParameter, and the txt boxes mentioned above don't show the cboParameter.Column information until after the called sub runs to completion.

I'd like this cboParameter.Column info to show up before the Private Sub is called. The sub asks dialog based questions and the cboParameter.Column info can help the user answer.

Thanks,
Mike

 

[Remou]

I think you will either have to run the sub from a button or else update the controls in the after update event that the sub runs in.

 

[TheAceMan1]

How are ya mguidry5 . . .

If you post the code of the private routine, I'm sure we can nail it! . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886