[RESOLVED] Waiting on query results B4 moving on

[VBStewart]

Does anyone know how to wait until a querys results display before movin on with the next part of code.

Query1 Runs
Result of query populates text1.text
query 2 runs where Text 1.text is then used as criteria

Although query1 only takes 2 seconds to populate text1.text, I think the query2 code is running before its there.
If I msgbox text1.text before the query2 runs it does show the correct data though.

Any thoughts?

[Hack]

Add a couple of DoEvents

Query1 Runs
DoEvents
Result of query populates text1.text
DoEvents
query 2 runs where Text 1.text is then used as criteria