Table additions without a form

Leesha · Post by **Leesha** » 26 Dec 2010, 19:39

Hi,

I have a frmOwnerInfo, which is bound to tblOwnerInfo. frmOwnerInfo is used to udate information. The user wants to keep a copy of the previous info vs overwritting it with the new info. Is there a way to add a new row to the table, that contains the updated info, while leaving the original info that loaded with the form the same? I had thought about setting up a temporay table that I would update and then append to the original table, but since I have to do this to 7 total tables, I thought I'd check first to see if there was an easier process with code that I could put behind a button.

Thanks,
Leesha

Post by **HansV** » 26 Dec 2010, 22:14

Another option would be to use an unbound form. Use code to load a record into the controls on the form, and when the user clicks the Save button, write the values to a new record.

Leesha · Post by **Leesha** » 31 Dec 2010, 01:30

Hi Hans,
I tried this approach and its working great! Thanks for the idea,
Leesha

Eileen's Lounge

Table additions without a form

Table additions without a form

Re: Table additions without a form

Re: Table additions without a form