Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Find Record in Main form based on selection in Sub

Author  Topic 

jpiscit1
Posting Yak Master

130 Posts

Posted - 2004-11-08 : 09:52:41
Can someone tell me how I migh find a record in a main form based a a selection in my subform?

I have a Main form called frm_ProductionSchedule.

It contains three subforms:
frm_ProductionSchedule_subform
frm_ProductionSchedule2_subform
frm_ProductionSchedule3_subform


I would like to be able to select a record within any of the subforms and have the main form display it. The main form is linked to a SQL server. The subform are based on queries. The unique PK field is a date field called record_date.

Thanks in Advance!!

John

Auric
Yak Posting Veteran

70 Posts

Posted - 2004-11-08 : 17:50:59
Whenever you go to search from the subforms, you could have a CMD button that will call a subroutine to make the main form go to the selected record..
Go to Top of Page
   

- Advertisement -