automatically check off a field in a table

[Parula]

Hello all, my husband recomended this site. He says there are geniuses out here. So here's my dilema.

I am creating a access file that outputs info to a mail sorter. My goal is to use zip codes to pull addresses from a huge local address database based on the users request of how many addresses he wants. Now after he chooses a certain number of addresses (say first 100 address in this zip code), after he chooses them, those addresses should not be availbile again for a subseqent request. In otherwords, if he choose 100. Then immedeiately he chooses another hundrend, I don't want the same addressed to be pulled.

Technically speaking:
When the user of this application I'm creating runs a quiery, he is asked to enter a zip code. My quiery will count the number of people in that zip code and give the user a figure. Now the users than enters the number of address from that figure he wants to pull and sent to the automatic mailer. I want to be able to update my customer records in such as way as to check off those that were chosen and already sent. (Therefore, when he does this quiery again, that number of total addresses in that zipcode should be decreased by that amount. I don't want him to send out the mailers to the same 100 people).
To do this, I created another field in my customer database called "sent, yes or no check box which is default to no". Now if I manual check off some boxes, my quiery responds the way I want it to. BUT I want this to happen automatically. I or the user shouldn't have to manul check off those that were sent. HOW CAN I RUN IT SO THAT IT AUTOMATICALLY CHECKS the BOXES.

I apologize for the length of this, I just am new an am learning how best to ask quesitons on this board.

 

[BoxHead]

Change the value from zero to negative 1.

checkbox.value = -1 'checkbox is checked

At some point in time, you will probably want to re-enter these addresses into the available pool for future mailings and you would use

checkbox.value = 0 'checkbox is unchecked

to uncheck the boxes.

If you will be reactivating these addresses, you might want to skip the checkbox and use a DateMailed field. If it's null, you haven't mailed anything to them. Later, you could run a query that would set this DateMailed field back to null if the date is more than 6 months old.

It sounds like a nice program. You may already be aware of this, but I've heard that the post office will provide zip-plus4 validation on 50,000 addresses for no charge. The plus four might give your customer a tighter selection area geographically rather than taking the first 100 sorted numerically or alphabetically.

 

[Parula]

Hi

I would like to reactivate these addresses after some time as passed. I don't know how to uset he DataMailed field. Can you explane it to me?