Will there be records that match down to the second?
It looks like this is a date/time from SQL Server : 2012-09-04 17:39:30.270 ?? Access chokes on the ".270" part. In Access you can convert the date/time to just the date by using the Int() function.
Code:
maxDate = DMax("[Record Creation Date]", "[dbo_Node Opt Birth Certificate]", "[Node Name] = '" & daNode & "'")
maxDate = maxDate = Int(maxDate)
You might try: (untested)
Code:
maxDate = DMax("[Record Creation Date]", "[dbo_Node Opt Birth Certificate]", "[Node Name] = '" & daNode & "'")
'convert to date only
maxDate = Int(maxDate)
DoCmd.OpenForm "Node Opt Birth Certificate - Field", , , "[Node Name] = '" & Me.[Node Name].Value & "' AND Int([Record Creation Date]) = #" & maxDate & "#"