Calling multiple function on Form Load

alex44

Registered User.
Local time
Today, 14:22
Joined
Aug 29, 2013
Messages
14
I'm trying to call a function multiple times, with different parameters, in the "Form_Load()" event. Unfortunately, it seems only the first call works; all following calls are ignored. I'm thinking that it may have something to do with the function already running when it's called the second time?
Here is the call code:

Code:
Private Sub Form_Load() 
    Call DD_RecordMisses("A", "A", "A")
    Call DD_RecordMisses("B", "B", "B")
    Call DD_RecordMisses("C", "C", "C")
    Call DD_RecordMisses("D", "D", "D")
    Call DD_RecordMisses("E", "E", "E")
    Call DD_RecordMisses("F", "F", "F")
End Sub
Access 2013 on Windows 7
 
That shouldn't be a problem. It won't come back until it's done with the function. Have you set a breakpoint and stepped through the code?
 
Pual,

Thank you for your reply. You are correct - the following function calls were working. The error was in my logic in the function itself (I'm not very VBA proficient). Your suggestion of the break points cleared it up.

Thanks,

Alex
 
Happy to help Alex!
 

Users who are viewing this thread

Back
Top Bottom