Lookup not working (1 Viewer)

I have a simple database that I need help with a Dlookup issue. Basically this database is used as a tracker for Pie in the face. You put the players name in then you put how much money is placed on that person. So far everything in this aspect works. I have a secondary sheet "Sheet1" This has how much each vote is. So 1 vote $.25. When you give a $1 you get 5 votes. So you cane never get 4 votes. Sheet 1 is my look up sheet. I need help with the DLookup. When I put an amount in the "AmountAdd" field then hit "Add" button I need it to look up how many votes and keep a running total of how many votes were placed in the "TotalVotes" field. I keep getting a data mismatch error.

This is not the final product. This is something threw together real quick while testing. The actual copy is being used. I did not make a backup copy.

Why do you have TotalVotes and TotalCollected as Text fields? Also why are you storing this--it seems like a calculated field, you should instead just make a query to determine this and not store the value.

In the actual Database TotalCollected is currency. I dint think to change it here because it wasn't being used in the current issue. TotalVotes I always had as a text field. I didn't think it would make much diffenece either way. Well I only have it store because there are more players. So they want the Total collected visible. I was a able to get a copy of the actual one. I wasnt able to get ahold of the person earlier.

So I actually figured it out.
Original Code:
Changed:

It works. I just had it looking in the wrong column. This was annoying.:banghead: