Edit memo field...save record to another table

[ppoindexter]

Good day all,

I have a table with several fields, one of the fields is set to memo...i need to be able to select a record from this table, edit the text in the memo field and then save (the actual edited text) in another table...keeping the original text in the memo field untouched ....so i can do this over and over as needed

Regards
plp

 

[Rob.Mills]

How are you going about doing this. Meaning are you editing the data in a form. Is the table that you're appending to have a relationship with the first table? For instance you've got the first table with several fields and then a second table that contains the id of the first for the relationship and then a second field for the memo so you can have many notes for the same record?

 

[ppoindexter]

as of now i havent created the second table....the existing table is

tbl_Level3
fld_Level3_id (key)
fld_Level3 (memo)
(with 7 addional fields)

I WANT TO USE A FORM TO EDIT THE MEMO FIELD

second table (not created yet as i was hoping to get some ideas before i made this change)

my thoughts on the second table:

tbl_Level3_Edits
fld_Level3_Edits_id (key)
fld_Level3_id (number) foreign key from tbl_Level3
fld_Level3_Edits (memo)

THEN CREATE A FORM THAT WILL PULL UP THE FIELDS FROM TBL_LEVEL3, ALLOW EDITS AND THEN SAVE TO TBL_LEVEL3_EDITS
WITHOUT MAKING ANY CHANGES TO THE RECORDS IN TBL_LEVEL3

fld_Level3 from tbl_Level3 records will be duplicated with edits many times...for instance

record number 231 from tbl_Level3 will be edited and saved into tbl_Level3_Edits numerous times...

thanks for your help Rob

 

[Rob.Mills]

Probably several ways to do this (always is). First thing that comes to mind is, setup the second table the way you thought.

Create a form for the first table with all relevant fields. Then in the memo textbox you can create a procedure to open a form that's linked to the 2nd table. You can do this by putting a procedure in the dbl click event of the memo field or putting a combobox next to it. Make sure that when it opens it goes to a new record.

Then in the form put an invisible textbox whose control source is fld_Level3_id (foreign key). Set it's default value to reference the id on the first form.

Then in the memo textbox set the default value to reference the memo field on the first form. They'll probably be some bugs to work out but this should get you moving in the general direction.

 

[ppoindexter]

would you happen to have a sample of the code for this event procedure??

 

[Rob.Mills]

First create your default values.

For the id field: Forms!1stFormName!IdFieldName

For the memo: Forms!1stFormName!MemoFieldName

Then if you choose to use a double click event on the memo field:

Private Sub MemoField_DblClick()

DoCmd.OpenForm "2ndFormName", , , , Add mode (think it's actually accmdAdd)

End Sub

That should be it. Let me know how it works.

 

[ppoindexter]

stay tuned...