Copy a record from one form to another from

[ShanVel]

Hi Folks,

I want to look up a record on Form1 and then copy that record (all fileds are of memo data type on the underlying table). Now I want to close Form1 and open another form (Form2) and set all the fields of Form2 to the record I copied from Form1 and save the Form2.

Do anyone have any idea on how to accomplish this via VBA. My VBA skill is not too bad.

Thanks/Shan.

 

[RuralGuy]

It is more normal in a relational database to leave data in only one location and put ForeignKeys in other tables that point to the record with the field you want.

 

[ShanVel]

Yes. I agre with you and that's how any RDMS works.

My intension for copying is to copy and then edit/modify that record for another project and save. Since I am dealing with lots of text (memo type) I thought it's a good idea to copy a record from another one and edit to save some typing.

I also agree that by doing a copy like this my tables are not going to be 100%normalized.

 

[RuralGuy]

I would use an Update or Append query to move the record.