How do you open a subform to a certain record when it contained on a page in a tab control?? Access 2010
Posted on 2012-04-10
I have a Form called frm_Main that contains a tabcontrol caled TabCtl0.
On there are 2 pages , Page1 & Page2.
Page1 has subform called Customers and Page2 has subform called Reports.
Basically How do i open frm_Main to Page1 to subform "Customers" with a value selected from a popup window.
I have this on the close of the popupwindow
I have it grabbing the value correctly on the close of the popupwindow
!TabCtl0.Value = !Page1.PageIndex 'gets the correct Page (Tab)
Me![Customers].RecordSource = "select * from tMaster where l_ID = 542"
'using a hardcoded value as a test
Any help or insight would be great..