[AccessD] Weird problem

Are you committing the record on the main form and recovering the PK from
it?  I seem to recall needing to refresh the view and look up the PK before
I could use it in a child record, since an autonumber isn't actually
assigned until you save the record in SS.

Charlotte Foust

On Tue, Jan 10, 2012 at 2:49 PM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> I have a FE recently moved to SQL Server.  Bound main form, bound child
> form.  I entered a record in the main form, entered a record in the child
> form.  Tried to modify the record in the main form and it gives an error
> "the data has changed" and refuses to allow me to change the data.  I can
> change it directly in the tables in SQL Server.  I cannot modify the record
> directly in the (linked) table in the FE.
>
> I could create the record, but not modify the record.  I can modify any
> other record in the table, just not the one I created.
>
> No idea why not.
>
> --
> John W. Colby
> Colby Consulting
>
> Reality is what refuses to go away
> when you do not believe in it
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
>
>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>
>
>