Display a Warning Message Box when Course Is Full

[djs45uk]

Hello

I have a form that looks like this:

http://www.st-pauls.w-sussex.sch.uk/enrichmentDB.jpg

You'll see that there are 3 subforms on it (a list of students, a list of choices they can pick from, a summary of how many students have picked each course).

Here's what I'm having trouble with:

When the user clicks on one of the options in the 'Final One' list, I need it to check how many students are already on this course. If the course is already full, I'd like the form to display a message box to warn the user that the course is full.

It may help you to know that each activity does have a unique identifier (activityID) although the form doesn't show it. The list on the right is generated by a query which counts how many students are enrolled on the activities.

I'd be really grateful if anyone can help me.

Many thanks

Daniel

 

[KenReay]

Hi

Using the .recordsetclone property may help you here

If we assume the Subform control with the list of students on the course is called frmStudentsOnCourse, and the main form is called frmMain then code like

if frmMain.FORM.frmStudentsOnCourse.Recordsetclone.recordcount >= iLimit then
msgbox "....blah"
end if

where iLimit is the number od students alowed on the course

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK