ScuzzyJo
asked on
Microsoft, Access, 2007, Call sub without return
Hi
I have an if statement where, if something is true, a sub procedure is called which performs various operations and then closes the current form. I don't want to return to the orginal procedure once the sub has been completed. If I use Call, it returns. How do I tell Access to go to a sub procedure and not return? I have an idea I might need to use Function, but I don't know how to so, if that's the correct way of doing it, please could someone tell me how to use it? If not, please could tell me someone how I call a sub without returning?
Thanks
Sarah
I have an if statement where, if something is true, a sub procedure is called which performs various operations and then closes the current form. I don't want to return to the orginal procedure once the sub has been completed. If I use Call, it returns. How do I tell Access to go to a sub procedure and not return? I have an idea I might need to use Function, but I don't know how to so, if that's the correct way of doing it, please could someone tell me how to use it? If not, please could tell me someone how I call a sub without returning?
Thanks
Sarah
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks. I had a nasty suspicion that might be the case...:-( The If was inside a Do.....Loop. I seem to have solved it by putting an Exit Do on the return, but I had fun trying to get the End If in the right place. It works now though, so thanks.
Sarah