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

[Guest]

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?

 

[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?

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

 

[Guest]

Thanks Hunter but it did not work.

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