g' day,
I want to find a record in form B based on a value selected from a combo box in form A.
I have cboSearchInd in frmCompany (which consist of a number of tab controls) based on qryContactNames which include fields ContactFirstName, ContactLastName, CompanyID and ContactID. The cbo displays 4 columns and is bounded on column 4 (ContactID). The AfterUpdate event of the cbo has the following code:
*******************
DoCmd.GoToControl "pcontact" '*** tab control that contains frmContacts
Forms!frmCompany!frmContacts!ContactID.SetFocus
DoCmd.FindRecord Forms!frmCompany!cboSearchInd.Column(3)
*******************
The first 2 lines of code work ok but on the 3rd line nothing happens. Any ideas?
thanx
Dave
I want to find a record in form B based on a value selected from a combo box in form A.
I have cboSearchInd in frmCompany (which consist of a number of tab controls) based on qryContactNames which include fields ContactFirstName, ContactLastName, CompanyID and ContactID. The cbo displays 4 columns and is bounded on column 4 (ContactID). The AfterUpdate event of the cbo has the following code:
*******************
DoCmd.GoToControl "pcontact" '*** tab control that contains frmContacts
Forms!frmCompany!frmContacts!ContactID.SetFocus
DoCmd.FindRecord Forms!frmCompany!cboSearchInd.Column(3)
*******************
The first 2 lines of code work ok but on the 3rd line nothing happens. Any ideas?
thanx
Dave