After control source

[Gregorys05]

Hi All,
I have a text box with a control source that pulls data from a query, because of this it takes a while for the information to populate, so i have created a loading form that displays on opening the form, what i want to do is then close the form once the query has run and the text box now has information in it, i have tried Afterupdate, on dirty, onchange. But still not having any luck.

Any ideas??

Thanks

 

[boblarson]

You can put a timer on the "loading form" which is set to TimerInterval of 1000 (one second). In the timer event on that form you can use

If Len(Forms!YourOtherFormName.YourTextBoxNameHere & vbNullString) > 0 Then
   DoCmd.Close acForm, Me.Name, acSaveNo
End If

So it should remain open until the text box is populated and then close itself. You don't need to change anything in this line:

DoCmd.Close acForm, Me.Name, acSaveNo

but you will need to supply the correct form and text box names to the part above it.

 

[Gregorys05]

Thats great that worked first time, thank you so much