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?

On Apr 20, 1:52 pm, Moe <M...@discussions.microsoft.com> wrote:
> 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

Thanks Hunter but it did not work.

"Hunter57" wrote:

> On Apr 20, 1:52 pm, Moe <M...@discussions.microsoft.com> wrote:
> > 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
>
>
>