This is going to take a while to explain so please bear with me.

I'm building an application for a community volunteer program. The way it works is:
someone submits a project (Table=Projects)
then a project leader (Coach) can review the submitted projects and take (organize) a project (once he takes the project it basicly copies the relevant project info into the coaches projects table (Table=CP1) and marks the project as Taken in the Projects Table)
The Coach can then edit the project details including how many volunteers it will take to do the project. (Table=CP1 Field=VolsNeeded)
Then Volunteers can see the coach-approved projects list and sign up to volunteer for any given project. When a volunteer signs up for a project it copies that volunteers id and the project id into the Volunteers Projects table (Table=VP1)

Everything seems to be working fine but now I'm faced with a toughy. I need to be able to stop volunteers from signing up once the total records of VP1 (for the project id in question) matches the VolsNeeded field in CP1.


I hope I explained that ok. Any ideas would be greatly appreciated.

Bill

try this
<b>

&lt;% If rsetVP1_total &lt; rsetCP1.Fields.Item("Volsneeded".Value Then %&gt;
&lt;form&gt;your sign up form&lt;/form&gt;
&lt;% End If %&gt;</b>


Edited by - Davecl on 16 Sep 2002 23:22:12

Edited by - Davecl on 16 Sep 2002 23:22:42

Thanks alot Dave,

Thats just what I wanted.
I put it on the forms submit button so that if the project is booked they can still see the details but now it tells them they can't sign up.
Perfect!

Thanks again,
(Every day you learn something new is a good day)

Bill

glad to help, glad it's working ok.