[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2087
  • 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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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