Adding content of a field into a begining of a memo field

M

Moe

In a form I have a calculated field that calculates its value using a
DLookup() function. I need the content of this field to show up inside a
memo field which is on the same form and user can add memo after that. I
need this to show up when we create or print a report from this form. How
can I do that?
 
H

Hunter57

In a form I have a calculated field that calculates its value using a
DLookup() function. I need the content of this field to show up inside a
memo field which is on the same form and user can add memo after that. I
need this to show up when we create or print a report from this form. How
can I do that?
Click to expand...

If your Memo field is empty, you can Use the After Update Event of
your DLookup Control. One drawback is it will replace anything
already in your Memo field.

Private Sub MyDLookupControlName AfterUpdate()

Me.myMemo = Me.MyDLookupControlName

End Sub

There is a way to add your data to what is in your Memo box without
loosing it, but I am not quite sure I can give you the correct
syntax. Perhaps someone else can help with that. I would like to
know how to do that myself.

Hunter57
http://churchmanagementsoftware.googlepages.com/home
 
M

Moe

Thanks Hunter but it did not work.

Hunter57 said:
If your Memo field is empty, you can Use the After Update Event of
your DLookup Control. One drawback is it will replace anything
already in your Memo field.

Private Sub MyDLookupControlName AfterUpdate()

Me.myMemo = Me.MyDLookupControlName

End Sub

There is a way to add your data to what is in your Memo box without
loosing it, but I am not quite sure I can give you the correct
syntax. Perhaps someone else can help with that. I would like to
know how to do that myself.

Hunter57
http://churchmanagementsoftware.googlepages.com/home
Click to expand...
 
Top