?
Solved

Running a procedure from anothe unrelated form

Posted on 2016-10-09
5
Medium Priority
?
74 Views
Last Modified: 2016-10-09
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
Comment
Question by:DatabaseDek
  • 2
  • 2
5 Comments
 
LVL 38

Expert Comment

by:Pawan Kumar
ID: 41835871
What error is coming? DuplicateRecordQueryWithSets is a procedure written in which database ?
0
 

Author Comment

by:DatabaseDek
ID: 41835874
Method or Data not found with "Forms." Highlighted

Same database
0
 
LVL 24

Accepted Solution

by:
crystal (strive4peace) - Microsoft MVP, Access earned 2000 total points
ID: 41835878
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
 

Author Closing Comment

by:DatabaseDek
ID: 41836014
I had brackets around form names.

Thank you
0
 
LVL 24
ID: 41836019
you're welcome ~ happy to help
actually the problem with the example was that it was "Me.Forms..." instead of "Forms..."
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Implementing simple internal controls in the Microsoft Access application.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question