Create a copy of a record to hold

[PharmaFun]

Hello,

I wish to be able to edit an existing datasheet entry in a form, without creating duplicate entries. So I thought I would create a "Save" button where the old entry is copied, the old entry is then deleted, and the new entry plugged into its place.

Should I use the dbRepMakePartial command?

Thanks,
Dino

 

[willir]

Dino

I guess there are several ways to do this ... but if your objective is to avoid duplicate entries, there may be a more simple way.

In the table design mode, you can set indexes for certain fields. Choose which field or fields you want to be unique and make sure their is an index and it is set to yes with no duplicates.

For more control on indexing, when in the design view, select the index button (lightening bolt to the right of a list). Enter an index name in the first column and select the appropriate field name for the second column. Set the index properties to unique and probably "no nulls". Then and a second field in the second column without creating another index name. This will force Access to ensure the tweo field together to be unique.

I think this is a better approach than to save a record before committing it.

Richard