Tech Support Guy banner
Status
Not open for further replies.

Solved: Access 03 - Call Modules/Procedures

861 views 2 replies 2 participants last post by  ddw23 
#1 ·
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 ·
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
Not open for further replies.
You have insufficient privileges to reply here.
Top