1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Access 03 - Call Modules/Procedures

Discussion in 'Business Applications' started by ddw23, Mar 28, 2007.

Thread Status:
Not open for further replies.
  1. ddw23

    ddw23 Thread Starter

    Joined:
    Jan 19, 2006
    Messages:
    109
    I have this procedure:
    Private Sub Form_BeforeUpdate(Cancel As Integer)

    This searches for empty fields and displays a message if any are
    found.

    I need this procedure to run when certain other buttons are
    clicked. I know I don't have to cut and paste this every time. I
    thought I could "call" the procedure...didn't work. So I cut and
    pasted it into a Module and named it "ReqFields" with the same
    procedure name...didn't work. I can't find good examples on the
    Net. Can anyone help me! I don't know much in this area.
    THANKS!!!
     
  2. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,667
    ddw, I am not sure what you named "ReqFields", was it the Module or the Sub?
    If it was the module then I would suggest it would be better to call the Sub either the same or something just as meaningful, do not use a Form's Event for it's name as it might confuse Access.
    If you re-name your Sub as ReqFields then use
    Call ReqFields

    to call it.
     
  3. ddw23

    ddw23 Thread Starter

    Joined:
    Jan 19, 2006
    Messages:
    109
    Thank you!
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/555633

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice