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

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?
Jass SainiAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
Can you please provide some context here? ..or a link to your "other question"?
The question here is unclear as it stands...
0
 
Jass SainiAuthor Commented:
Hello Scott,

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

From novice to tech pro — start learning today.