carry over field

[New TO Access]

I need to carry data over from one field in a record to the same field in a
new record. It is a memo field that contains a schedule of people attaching
to one client.

I have read the posts about setting the Default Value but that is not what I
am trying to achieve.

I want the data contained in the latest recordset of a client to carry over
into a new record but the data must be specific to the same client.

Would appreciate any assistance.

Thank you

David

 

[John W. Vinson]

I need to carry data over from one field in a record to the same field in a
new record. It is a memo field that contains a schedule of people attaching
to one client.

I have read the posts about setting the Default Value but that is not what I
am trying to achieve.

I want the data contained in the latest recordset of a client to carry over
into a new record but the data must be specific to the same client.

Would appreciate any assistance.

Thank you

David

There's something wrong with your table design, then. Storing the same
schedule redundantly in multiple records should not be necessary! What's the
structure of your tables? Why do you feel you need to copy this data?

 

[New TO Access]

The reason I need to duplicate the schedule is so I can change it on the next
record. The reason a new record is created is because of additions/deltions
to the schedule. Each record needs to store the schedule as it was at a point
in time for audit purposes.

 

[New TO Access]

Thank you for responding - apologies for delay I have been away.

I understand your comments in respect of memo fields but in this case it
works for me. The data is never interrogated in any way and I simply use it
to attach a schedule to a certificate. I am intrigued however as to what
alternative I have.

I have 160 companies in a scheme who on average have approximately 8 members
so I have over 1,000 names that need to be recorded.

Anyway, back to the original question, the code you provided me with didn't
work and I have tried this before. Is it anything to do with Access 2007?

Thanks

 

[New TO Access]

Unfortunately, that's not the problem. All my other code runs fine.