Solved

How do you have the Memo Box only update the records that were in the query with the same comment?

Posted on 2015-01-12
3
136 Views
Last Modified: 2015-01-20
Hello,

Slightly different questions then my other question.

How do you have the Memo Box only update the records that were in the query with the same comment?
0
Comment
Question by:Jass Saini
3 Comments
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 40545990
Can you please provide some context here? ..or a link to your "other question"?
The question here is unclear as it stands...
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 40546296
To add to what Jeff said:

A Memo box on a Form is bound to an underlying field. Changes to that Memo box would affect the data in that field, but only in the specific record the form is "pointing" to at the time.

If you want to include a button to update the same field for other records, you could do this:

Currentdb.Execute "UPDATE YourTable SET YourMemoField='" & Me.txTheMemoControl & "' WHERE <your criteria here>"

Note this can be troublesome with bound forms.
0
 

Author Comment

by:Jass Saini
ID: 40549168
Hello Scott,

I understand most of the syntax except for "The MemoControl"...you mean like if it a click or AfterUpdate??
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

770 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