Limit number of entries for a record

[marcygriebel]

We have a Healthy Life MS Access database where a person's number of blood pressure check ups are recorded and they are paid $2.50 for each checkup with a maximum of 2 entries (or $5.00 per year). How do I create a rule on the form so that the user is alerted when attempting to add a 3rd checkup, which exceeds the maximum.

[Rabbit]

Using an appropriate event, in your case, it sounds like you want to use the before insert event or before update event, use a DCount() to find out how many that person has. Then cancel the insert or update if they already have two.