OnClick take data in memo field and write to memo field on another form

Posted on 2005-05-03
Medium Priority
Last Modified: 2012-05-05
When a users clicks, I wish to take the value that is shown in a Memo field EventDateInitial on form Event_Type_And_Details and add this into the memo field ContactDetails on form Aim_Contacts.  

To make this a little more difficult, I wish for the user to be able to use this option to add the data from the EventDateInitial field onto a new line at the TOP of the memo filed ContactDetails.  So each time the user clicks on the button it takes the value from field EventDateInitial on Form Event_Type_And_Details adds a fresh line to the TOP of the field ContactDetails on Form Aim_Contacts and in this new line inserts the data across.

Hope this makes sense

Question by:wobbled
  • 2
LVL 15

Accepted Solution

will_scarlet7 earned 2000 total points
ID: 13918283
I think if you put something like this in your "OnClick" even, it should work:

    Forms!Aim_Contacts!ContactDetails = Me!EventDateInitial & VBCRLF & Forms!Aim_Contacts!ContactDetails

This is assuming that the button that the user clicks in on your "Event_Type_And_Details" form.
LVL 17

Author Comment

ID: 13918480
Excellent - just what I needed
LVL 15

Expert Comment

ID: 13918544
Happy to help!
God bless!


Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question