create macro in access: tally votes

F

Flathead_daddy

Hi- What I desire to do is fairly simple. I want to create a simple voting
form which will require a macro. The form will contain two objects: a
numerical field to be entered by the user and a button.

First the user enter's a number on a voting form, which selects the "Person
Number" (a field that has already been populated using another form) and the
current number of votes that that person has (another field from the same
form). Then the user clicks the "vote" button, which will increment a vote
field by one, and save the data in the table. Then the macro ends.

The user can then vote again for the same person, or enter a new number and
choose to click the "vote" command.

Can anyone please help me? Thanks in advance.
 
S

Steve Schapel

Flathead,

You can use a SetValue acrion in your macro. The arguments will be like
this...
Item: [NumberOfVotes]
Expression: [NumberOfVotes]+1

As far as I can tell, that's all you will need.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top