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

Change a value in a table using Access 2010 macro.

I want to use a macro to open a table, go to a record and then enter data in a field. Below is a picture of my macro up to the point where the record is selected.

Now which action can I use to give a value to a specific field in that record. The fieldname is "Note" and I want to enter "This is the new value." in that field.

Applicable picture
0
Fritz Paul
Asked:
Fritz Paul
1 Solution
 
JimFiveCommented:
I don't think you can.  Is there a reason you want to use a Macro instead of an update query?
0
 
Fritz PaulAuthor Commented:
Thanks, You'r right. I read more about update queries and understand the limitations of macros vs update queries better now.
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

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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