Copying memo field comments to other queried record (1 Viewer)

[Jass7869]

Hello,

I have one memo per change (user input)...I need to have the comment the user inputs to copy into other records that were queried. I tried insert. My coding does one of the records or all of the records ..I need it to copy just to the queried records ...and I have a query but no filter set.

 

[Steve C]

Hi Jass.

Convert your Query into an Update query.

set the "UpDateTo" field (where you want the comment to be written) in the Update Query to:
Forms!YourForm!CommentField

YourForm is the name of the form where the comment is being entered

CommentField is Text Box where the comment is entered

have a button run the Update query. the comment will appear in every record.

SteveC

 

[Jass7869]

I am getting a error that says "Operation must use an updateable query" and I did convert it to a Update query

 

[Jass7869]

Also..unfortunately I have 10 comment boxes on each of my four forms....

 

[Steve C]

Some queries return un-updateable data. I can't find my link to how I know that or remember what the circumstances are which produce the problem.

I have a query field which takes the "The" off of the beginning of a field (if any) and puts that "The" in brackets at the end of the field - for A-Z sort. When I use this query as part of another query the datasheet is not updateable.

What if you create a new query based on your current query? Will that query produce editable results?