• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 77
  • Last Modified:

Running a procedure from anothe unrelated form

I am using this. It does not work. Tried all manor of combinations

Call Me.Forms.[ProjectForm].[Details].Form.DuplicateRecordQueryWithSets

DuplicateRecordQueryWithSets     is the procedure
0
Derek Brown
Asked:
Derek Brown
  • 2
  • 2
1 Solution
 
Pawan KumarDatabase ExpertCommented:
What error is coming? DuplicateRecordQueryWithSets is a procedure written in which database ?
0
 
Derek BrownMDAuthor Commented:
Method or Data not found with "Forms." Highlighted

Same database
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
if you are using an absolute reference to the procedure, don't start with Me
   Call Forms.f_Master.f_Child.Form.ProcedureName

Open in new window


make sure the procedure is PUBLIC that you are calling. For instance:
Public Sub ProcedureName()
   'code goes here
End Sub

Open in new window

if you are calling this from code behind the master form, you can do this:
      Call Me.f_Child.Form.ProcedureName

Open in new window

0
 
Derek BrownMDAuthor Commented:
I had brackets around form names.

Thank you
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~ happy to help
actually the problem with the example was that it was "Me.Forms..." instead of "Forms..."
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now