[RESOLVED] Waiting on query results B4 moving on
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?
Re: Waiting on query results B4 moving on
Add a couple of DoEvents
VB Code:
Query1 Runs
DoEvents
Result of query populates text1.text
DoEvents
query 2 runs where Text 1.text is then used as criteria