>When I add a new record to may table via ado and odbc my "default" value is not entered into my primary key. If i just open it in vfp and append or insert a record it works just fine.
>
>Is there a way to make this happen via ADO?
>
>Thanks in advance...
>Tommy

Is the data source a DBF / DBC?

You may have to requery the recordset to see any primary key values assigned at the backend.