I have a main form that has a tab form with multiple subforms on each tab. I would like to create a button on one of the subforms that would jump to another subform that is on a different tab and match records based on a common field. For some reason the event procedure I wrote a month ago worked find and now it doesn’t. Could someone take a look and give me suggestions. I have looked at the code for some time now and cannot figure out what is wrong. Thanks in advance.
The button has the following code:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.GoToControl "RevenueInfo" (subform on different tab control – this step works)
DoCmd.FindRecord (Forms!Company!ContractInfo.Form!ContractDetailsdatasheet.Form!job_id, acEntire, False, , False, , True (common field between both subforms is “job_id” - this step does not seem to work)
when I click on the button it takes me to the right subform but does not take me to the right record.!! very frustrated. It also does not give me any error message.
The button has the following code:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.GoToControl "RevenueInfo" (subform on different tab control – this step works)
DoCmd.FindRecord (Forms!Company!ContractInfo.Form!ContractDetailsdatasheet.Form!job_id, acEntire, False, , False, , True (common field between both subforms is “job_id” - this step does not seem to work)
when I click on the button it takes me to the right subform but does not take me to the right record.!! very frustrated. It also does not give me any error message.
