Hello,
I'm trying to use connect a ComboBox to a query, wherein picking a field in the ComboBox would pass a parameter that would filter my query. However it's not working. I''ve attached this to my ComboBox:
and this in the Parameters of my Query:Private Sub Combo65_Enter()
DoCmd.OpenQuery "thisweek", acViewNormal
End SubAll thats happening is that the query opens up but with no data in it! However i've confirmed multiple times and there is data for this time period. Any ideas?Like [Forms]![Timecard]![Combo65]