Timing Issue

[Ajwebb]

I have a form with two list boxes on.

On the open event my first list box requeries.

Is it possible to delay my second list box from requerying until the first one has finished.

Thanks for any help

Anthony

 

[kraxmo]

Hi AJwebb,

One way to do this is to leave the second list box's ControlSource property blank and populate its value immediately after requerying the first list box.

In your case, all bound form objects (including the form itself) are requeried when you open the form. In the OnLoad form event, try assigning the value of the property to some data source.

Example:

Private Sub Form_Load()
Me.List0.ControlSource = "somedatasource"
Me.List0.Requery
DoEvents
End Sub


Jim Kraxberger
Developing Access solutions since 1995
jkraxberger@scp4me.com

 

[Ajwebb]

Thanks Jim,

I will give it a try.

Anthony