Solved: Access 03 - Call Modules/Procedures

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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!!!
 

OBP

Joined
Mar 8, 2005
Messages
19,895
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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Members online

Top