MS Access 2003 Validation Rules for Forms

[mfleming]

Hello.

I'm have a database setup for our wedding. I have a form to enter RSVP responded (checkbox), RSVPInvited(##), RSVPAttending(##).

1st question.

1. I want to be able to disable the RSVPResponded(Checkbox) after I close down the form so I don't accidently uncheck it the next time I come into the form.
b) How do I add a running total to my report of the numbe of people responded?

2nd Question.

2. I want to make a validation rule in the form to check and make sure when I input the RSVPAttending(##) it is equal to or less than RSVPInvited(##).
b) How do I make a running total of RSVPAttending and RSVPInvited and add that to a form?

I tried putting this into validation for the RSVPAttending:
=[RSVPAttending]=[RSVPInvited] Or [RSVPAttending]<[RSVPInvited]

But it doesn't work.

3rd question.
How to I add a search to my forms so I can input characters into the LastName spot and it will come close to the location of the person. (ie. just like when u use your address book in Outlook).



Thanks

Matt

 

[mfleming]

Question 2-b Addition:

I can make two querys one having all the FirstName, LastName, RSVPResponded, RSVPInvited, RSVPAttending, but I can't add the this "SumInvited: Sum(Addresses!RSVPInvited" ect. But If I create a new query from Address.Table I can enter "SumInvited: Sum(Addresses!RSVPInvited)" ect. and it comes out with the totals.

The only problem is I don't know how to combine both querys with these values to use in a Report?