[MS_AccessPros] Syntax error Mission operator

 

I am working in the Immediate Window to test my code piece by piece. It was working great as I am 75% of the way through and I ran into error I cannot solve.

Why would this code work (compares location ID's)
? DLookup("[fscFscID]","t_FacilitySchedule","fscFacID=" & [forms]![f_8TeamSeasonSchedule]![cboLocDay1]

...and this code gives me a Null return, should be 2 (Compares schedule dates)
? DLookup("[fscFscID]","t_FacilitySchedule","fscSchDate=" & [forms]![f_8TeamSeasonSchedule]![hlpDay1Date])

...and this code gives me an error (compares start times)

? DLookup("[fscFscID]","t_FacilitySchedule","fscStartTime=" & [forms]![f_8TeamSeasonSchedule]![hlpGame1Time])

I have tried to enter the ## but I must be getting it wrong and I can't find any good models. How do I format Dates and times to get them to compare to each other?

Thanks for you assistance,
Bill

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___