Update Memo field using VB in a form

G

Guest

I have a form that opens a record to edit based on the recored selected in
another form. I am trying to set three fields in a form prior to opening the
form. One field is a date field, one a text field and one a memo field. The
date field and the text field are updated when I open the form but the memo
field does not get reset to the value I am trying to set it to until I put my
mouse curser in the cell. Is there any way to make the memo field also
update?

The code:
[Forms]![NewFORM]![Date]=Date
[Forms]![NewForm]![Test].value = "text message"
[Forms]![NewForm]![Memo].value = "memo message"

Thanks for any help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top