G
Guest
I have a combo box on a form for the user to select a Project Number. After
selected, they can open a new form that would filter that Project Number and
show that record in the new form. However, my code isn't working. It just
pulls up the first record in that table. Can someone help me with the codes?
Here is what I have for the button to open the new form:
DoCmd.OpenForm "frmApplication", acNormal
Dim holdID As Long
holdID = Me.cboChildren
DoCmd.GoToControl "ProjectNumber"
DoCmd.FindRecord holdID, , True, , True, , True
End Sub
selected, they can open a new form that would filter that Project Number and
show that record in the new form. However, my code isn't working. It just
pulls up the first record in that table. Can someone help me with the codes?
Here is what I have for the button to open the new form:
DoCmd.OpenForm "frmApplication", acNormal
Dim holdID As Long
holdID = Me.cboChildren
DoCmd.GoToControl "ProjectNumber"
DoCmd.FindRecord holdID, , True, , True, , True
End Sub