Each tab is a subform associated with a table. One of the tabs is related to correspondence with the tax payer. On the form are fields associated with land parcel number, billing number, type of correspondence, date sent, date respondence due, date responded, response type, along with a memo field. The memo field is used to make notes. At times the auditor will want to update the notes, I did not want to loss the original notes. All the above fields are bound to the table. I added an unbound textbox to capture any new notes. I would then update the memo field either with the textbox losses focus or a new tab is selected. If any of the bound fields have changed, a before update of the table record is fired. However, if only the textbox has added data entered and the tab is changed then I don't get the before update event. Note the bound fields are not allowed to change once the record has be committed, thereby forcing a record if a new correspondence is started. In short the record is used to track a single correspondence from beginning to end with only notes being possibly changed.
I hope this explains my thought process. Traceability is critical for this app.
Rod
---In ms_access_professionals@yahoogroups.com, <JohnV@...> wrote:
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@...
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 (4) |
Tidak ada komentar:
Posting Komentar