Rod-
Are the controls displaying the memo fields bound? If so, I imagine you are using a subform on each tab because you say each memo is in a different table. Moving the focus to a new tab should force an update in the subform on the previous tab, so you should see AfterUpdate fire for the unbound text box.
Help me understand better how your form is laid out - including Record Sources and any subforms.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of desertscroller@cox.net
Sent: Wednesday, November 27, 2013 3:26 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Help with updating Memo field
I am using a tab control with 8 tabs. In each tab control a memo field is used to track notes associated with the data contained on the table. (Each tab is associated with a table in the database.) I was wanting to add new notes to the beginning of the memo field (including a datetime stamp and user name). To accomplish this operation I was planning on using an unbound textbox for new notes then append to the memo field once the focus is lost on the textbox. However, the issue is when the user moves to a new tab without taking focus of the textbox (lost of focus is not triggered). Is there a way to accomplish both operations? If other data (bound to the table) is changed then beforeupdate of the bound data is trigger which would allow making the changes to the memo field. Any ideas.
Rod
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar