Running a Sub Procedure

  • Thread starter Thread starter alan fisher
  • Start date Start date
A

alan fisher

I have a procedure that works fine, its just a bit bulky
and I want to trim some code out and run it from a sub.
Specifically I am createing 3 tables and want to create
them in a sub. The code I'm using now in the main
procedure works just fine. So I created a public sub for
one of the tables that looks like this:

Public Sub MakeTabel_tblActs_Qc_Num_Eff_Misns()

I then copied all the code that works just fine in the
main procedure and put an end sub at the bottom.

I then used this line to call the sub

Call MakeTabel_tblActs_Qc_Num_Eff_Misns

When I step through the code with the debugger it runs
through the sub but never actually creates the table.
I get no errors and it finishes the sub and returns to the
main procedure.
I know there is some word or comma or something I must be
missing but I have been looking through all sorts of
documentation trying to figure this out. Please Help.
thanks.
 
-----Original Message-----
I have a procedure that works fine, its just a bit bulky
and I want to trim some code out and run it from a sub.
Specifically I am createing 3 tables and want to create
them in a sub. The code I'm using now in the main
procedure works just fine. So I created a public sub for
one of the tables that looks like this:

Public Sub MakeTabel_tblActs_Qc_Num_Eff_Misns()

I then copied all the code that works just fine in the
main procedure and put an end sub at the bottom.

I then used this line to call the sub

Call MakeTabel_tblActs_Qc_Num_Eff_Misns

When I step through the code with the debugger it runs
through the sub but never actually creates the table.
I get no errors and it finishes the sub and returns to the
main procedure.
I know there is some word or comma or something I must be
missing but I have been looking through all sorts of
documentation trying to figure this out. Please Help.
thanks.
.
I figured it out myself. I forgot to add a line of code
Click to expand...
to the sub. The one that sets db = CurrentDb(). I also
didn't need the word Call before the sub name.
 
Back
Top