Hi Opencurrent Report from sub_sub_ form (1 Viewer)

nilesht

New member
Local time
Today, 07:40
Joined
May 18, 2017
Messages
1
Hi
Respected sir
I am Nilesh from India
I am Having one Main Form and two Sub form say sub forma1 and sub form2
Sub form1 is link with Main form and sub form2 is link with sub form1
I want to open Report say Report1 with current report of sub form 2
how to do this on click of button on main form using Micro
i am not familer with vb code.
Can u do it or suggest how to do it with Micro code.
Can I attach My access File ? Can u do it for me ?
Thanks.
This is my first post
please help me
 

June7

AWF VIP
Local time
Yesterday, 18:10
Joined
Mar 9, 2014
Messages
5,465
I don't use macros. VBA code like:

DoCmd.OpenReport "report name", acViewPreview, , "ID=" & Me.form1!ID

Tried but can't get macro to work.
 

Users who are viewing this thread

Top Bottom