• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 164
  • Last Modified:

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?
0
Jass Saini
Asked:
Jass Saini
1 Solution
 
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now