Simple Form Rule Will Not Work

First of all to put this in context, I run a golf course and am trying to build a really simple tee sheet that lists the names of golfers signed up to play at a particular time.

We encourage people to sign up as threesomes or foursomes.

I have a pre-made table, that includes a record for each tee time for the day.  To make it simple, lets say that table has six fields, time, one field for the name of each golfer in the foursome and a formula field "total number of players" that counts the number of golfers in that record. (and the counter works).

As we want to encourage golfers to sign up as a threesome or a foursome, I want a very simple form rule that fires a message if the number of players in the record is less than three.

So, I have a form rule that says if "total number of players"<=" 2 "display the message" you must book a minimum of three players

When I modify a record and only enter one or two names, the counter shows "1" or "2" but when I hit save, no message is displayed? 

It seems simple to me, but I have been fighting with this all afternoon.....

Jeff





------------------------------
Jeff Rogerson
------------------------------