Search results
-
K
DLOOKUP with multiple date criteria one of which is function
I'm persistent-this works. Key was to remove single quotes: Broke: '"[systemID]=" & Me![cboSelectSystem].Column(1) & "' Works: "[systemID]=" & Me![cboSelectSystem].Column(1) & " Me.txtCurrentUsage = DLookup("[numUsers]", "tableSystemUsage", "[systemID]=" & Me![cboSelectSystem].Column(1) & "...- kdwoell
- Post #2
- Forum: Modules & VBA
-
K
DLOOKUP with multiple date criteria one of which is function
Please..pls...pls someone fix this pls ...before I slit my wrists and gun down my co-workers...... Me.txtCurrentUsage = DLookup("[numUsers]", "tableSystemUsage", "[systemID] = " & Me![cboSelectSystem].Column(1) And DateValue([usageDate])=#7/15/2008#") ERROR: "compile error - expect list...- kdwoell
- Thread
- Replies: 2
- Forum: Modules & VBA