Memmo Madness 2!

[narcan2k]

Now that the cold is gone... let me try to explain this proper.

What i am trying to do is this:

The db i am creating will be used to update client information. there is a section for case notes on the form. I want to create a macro that will cut the text from memofield1 and paste it to memofield2 on the same section of the form. memofield 2 will be read only.

In addition, I need the text pasted into memofield2 to be added to text already there so that it dosn't overwrite previous notes.

One more little detail. I have a command buton that time and date stamps into a memmo field however i cant figgure out how in the name of the access gods to have it stamp the memo and start a new line so that the notes entered will begin on the next line in the memo. I did it once before but cant seem to make it work again.

Please help!

 

[Mile-O]

Do you propose to do this on the click of a button? If so, you'll find it a hell of a lot easier with a bit of code.

If you need help with code then just ask.

 

[narcan2k]

That would be appreciated...

To be honest, I don't even know were to start. This is all new to me. any help would be appreciated!

 

[bjackson]

did you try what i posted before?
did it work?
use the setvalue option in macros
if you dont want to overwrite memo field 2


item =iif(not isnull(forms![yourformname]![memofield2] ,
forms![yourformname]![memofield2] & " " & forms![yourformname]![memofield2] ,forms![yourformname]![memofield2] )

expression=forms![yourformname]![memofield1]

select setvalue again
item =forms![yourformname]![memofield1]
expression=null

or as Mile-O-Phile suggests code would be a lot easier

 

[narcan2k]

ThanX

It worked like a charm thanks for your help!