Update details of subform without DB replication (1 Viewer)

[noboffinme]

Hi

I have a database (2003 mdb file) with a subform.

I'd like to allow the users to print off their own records from the subform, make any changes they need, & then regularly upload these changes back to the subform. (Of course, they would convert the file back to softcopy in order to upload)

I want to avoid replicating the whole database for this purpose.

What's the best way to achieve this?

 

[dcb]

Export to Excel

http://www.btabdevelopment.com/main/CodeSnippets/SendFormsRecordsettoExcel/tabid/120/Default.aspx

 

[noboffinme]

Thanks dcb

Now that the data is in excel, how can I get it back into Access & include any additions/changes that have been made?

The users are going to extract their records, make additions/updates & want those changes updated in the database.

I'm thinking an update statement to a subform is what's needed, & I don't want duplicate records left on the table.

Does anyone have a working example of an update/delete duplicates code sample?