Limit New Records (1 Viewer)

[Harrier]

Hi,

I have developed a database for the provision of training courses at the college. Each course tutor has a limited number of places available. How can I book students on the course but when I reach the limit receive a warning that the course is full and prevent any furthur bookings.



Thank you for your help

Harrier

 

[llkhoutx]

You've got to count them or keep track of how many you have. Use a recordset clone recordcount to do this.

When you reach a threshhold warn course is almost full, or full as the case may be. In the later case, set allow additions to false.