Coming accross something strange and i dont know whats going on.
So i am using a lookup on a table and checking a date field.
Certain dates work, certain dates dont and i cant work out why.
DLookup("[F-GasLogID]", "[F-GasLogs]", "[actiondate] = #" & Forms![FrontEnd]![F-GasLog_Add].Form.[Actiondate] & "#")
for instance:
23/07/2009
23/06/2010
09/09/2011
14/10/2011
all work and return the ID
06/09/2011
12/08/2011
dont work, returns null
and all are unique dates.
Spent nearly all day trying to work this out and im stumped.
Please help :banghead:
So i am using a lookup on a table and checking a date field.
Certain dates work, certain dates dont and i cant work out why.
DLookup("[F-GasLogID]", "[F-GasLogs]", "[actiondate] = #" & Forms![FrontEnd]![F-GasLog_Add].Form.[Actiondate] & "#")
for instance:
23/07/2009
23/06/2010
09/09/2011
14/10/2011
all work and return the ID
06/09/2011
12/08/2011
dont work, returns null
and all are unique dates.
Spent nearly all day trying to work this out and im stumped.
Please help :banghead: