I have a combo box that has this as its row source (it's just a select statement that brings up the options we want, I don't think it needs to be scrutinized):
And this is what happens after the combo box is updated (the whole form is supposed to be updated with data for the selected option)
When using the combo box, it works for some selections, but not others. (The same selections do and don't work all the time.) At first glance, there seems to be absolutely no difference between the ways numbers that do and don't work are set up in the database.
Does anyone know why this AfterUpdate event might not work as planned? Or any suggestions as to how to troubleshoot it?
Thanks in advance!
Code:
SELECT tblTestStationEquipmentList.elTEptr, tblTestStationEquipmentList.PartNumber, tblTestStationEquipmentList.Item, tblTestStationEquipmentList.EquipmentID, tblTestStations.TS_Part_Number AS [Test Set], tblTestStations.AreaRefNo FROM tblPartMaster INNER JOIN (tblTestStationEquipmentList INNER JOIN tblTestStations ON tblTestStationEquipmentList.elTEptr=tblTestStations.TEid) ON tblPartMaster.Product_Part_Number=tblTestStations.TS_Part_Number WHERE (((tblPartMaster.ProductTypeId)='ITA')) ORDER BY tblTestStationEquipmentList.PartNumber, tblTestStations.AreaRefNo, tblTestStationEquipmentList.Item;
And this is what happens after the combo box is updated (the whole form is supposed to be updated with data for the selected option)
Code:
Private Sub GetAnotherTS_AfterUpdate()
Dim lvr As Long
lvr = Me.GetAnotherTS
Me.[GoToPoint].Visible = True
Me![GoToPoint].SetFocus
DoCmd.FindRecord lvr, acEntire, False, , True, acAll, True
When using the combo box, it works for some selections, but not others. (The same selections do and don't work all the time.) At first glance, there seems to be absolutely no difference between the ways numbers that do and don't work are set up in the database.
Does anyone know why this AfterUpdate event might not work as planned? Or any suggestions as to how to troubleshoot it?
Thanks in advance!