copy and paste field to field

[nick5196]

Hi,
I am trying to create a code which will copy the contents of a "date/time" field to a "memo" field when the value of the "date/time" field changes. I am unsure of the code which i should use to copy this field to the other. I have attached a copy of the database to prevent confusion.

*I would like the contents of the memo box to remain each time a new date is selected-a basic way of recording the dates.

p.s if anyone knows of a better way I could keep a record of the dates which have been selected that would be very useful

Thanks allot
Nick

 

[boblarson]

p.s if anyone knows of a better way I could keep a record of the dates which have been selected that would be very useful

Yeah, use a table (which is the normalized way to do it). Then you can actually query that instead of a memo field where you can't.

 

[nick5196]

Thanks allot, that seems a much better way of doing things.
Could you explain what the "enter parameter" box means each time I load the main form? and how I could possibly stop this?

 

[boblarson]

Could you explain what the "enter parameter" box means each time I load the main form? and how I could possibly stop this?

Sure - I forgot to remove that field from the main form's record source and as I had deleted it from the table the form can't find it. Just open the form in design view, go to the record source property and click the Ellipsis(...) and then you'll find that field at the very end of the query. Remove that field from the query, close and save and you should be good to go.