Pop_Access
Member
- Local time
- Today, 14:29
- Joined
- Aug 19, 2019
- Messages
- 66
I have table (tbl_Date) contains two primary keys (Date & shiftID), I designed a search function and the results will be display in combo box, but if i selected one of them the form will not go to the selected record.
the error in the following code:-
Note:-
As you know each day contains more than one shift (A,B, and C).
Thank you
the error in the following code:-
Code:
Private Sub cmbSearchList_AfterUpdate()
DoCmd.SearchForRecord acDataForm, "frm_bed", acFirst, "[txtdate] = " & Me!cmbSearchList.Column(0) & "[txtshftID] = " & Me!cmbSearchList.Column(1)
End Sub
Note:-
As you know each day contains more than one shift (A,B, and C).
Thank you