I’ve got a (basic?) question…

Say I’ve got the the following sub

sub abc()
  Sub2
  Sub3
end sub

subroutine abc calls sub2 and then sub3. I need to know if ALL the contents of sub2 will be executed first then sub3 or will vb call sub2, then immediately call sub3 and process them side by side?

For me it’s important that sub2 get executed completely b4 sub3. Here’s what I’m actually trying to do:

sub2 will load data from a table and put it into individual drop down lists. sub3 will set the listindex of all those drop down lists according to a parameter i pass depending on which record should be selected in the lists, so if there is a lot of data and if sub2 and sub3 get executed simultaneously, the data that might get passed to sub3 might not have even got loaded from the database and this could cause serious problems.

If sub3 is executed only after the whole of sub2 is executed then there will be no probs.

TIA and sorry for the silly ques.  :oops:

Sub2 will finish what it’s doing before returning to abc. Then Sub3 will get called. You don’t have to worry about the calls being processed out-of-order unless you’re using threads or calls handled by different event handlers and you never have to worry about simultaneous execution in VB.

Get in the habit of using On Error Resume Next and On Erro Goto statements to do error handling to try to anticipate possible problems and deal with them.

Thanks for the help. In sub’s that have database related statements I do use on error goto <label> to catch errors.

Geeks
hehehe
:D

I believe you are one of those typical rich spoilt brats who only knows how to party and waste your life?

“Fat, drunk, and stupid is no way to go through life, son.”