I have a problem with Video 2: When i try to build my own list box, DblCLick event
My code:
Private Sub Leave_DblClick(Cancel As Integer)
    
    DoCmd.OpenForm "F_Employee List", , , "Clock ID=" & Leave

End Sub

when i try to run it, it show this -- syntax error (missing operator) in query expression Clock ID=7041231'

I am wonder what is not right here? Hope you could give me some advise. Thank you.

---

Reply from Richard Rost:

I see a space in your field name "Clock ID". If so, you violated one of my rules from Access 101... NO SPACES in your field names. If that's the case, you need to say:

DoCmd.OpenForm "F_Employee List", , , "[Clock ID]=" & Leave