By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,337 Members | 2,048 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,337 IT Pros & Developers. It's quick & easy.

Referencing Access Cells with VBA

P: 1
I'm creating a form which corresponds with an existing table. I want the form to be able to update a single field in that table using different command buttons. Each command button represents a different number (1-10). I want to put the corresponding number in the table and be able to move to the next row. How do i reference this for VBA code in Access?
Feb 24 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
You need to design a form with a TextBox control for the field you wish to update. Also on this form, you must place the CommandButton controls to be clicked. In the Click event of each CommandButton you need code to set the value of the control and, optionally, to move forward one record (which automatically saves the updates for the current record).
Feb 24 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.