It depends on what you mean by "will not work". If the data appears, but the subform won't let you update, the problem is likely to be in the RecordSource...
We got this same problem using Access/ODBC to retreive an Oracle query result. The only solution we found was on Oracle side: We changed the date to a character string in the...