I set the recordsource of an ADO data control to a SQL 7 query. The
control is the data source for the fields of a form. When I type into
the fields and then do .update the results are reflected in the SQL
table. When I try to stuff a field directly i.e.
ADODC.recordset.field("Name").value = "Jimmy" and do the .update it
doesn't take in the SQL table. Anybody know why?