how to fix the number of records shown in a continous form

[paulevans]

I am creating a booking system that allows three different departments in our company to invite up to two guests to an event.

I have created a single form called event which lets me select the three departments. on this form there are three sub forms linked to the departments.

These sub forms are scaled so that three records (Guests) are shown. what I would like to do is change these forms to show only two guests (records).

I also would like to be able to change this so if a department did not want to take any guests his place and his guest places are then added to another department. So the other department would now be able to take a total of 5 guests. so my sub forms would show zero records for the first department, 2 records for the next department and 5 records for the 3rd department.

Is this possible?

 

[Uncle Gizmo]

>>> Is this possible? <<<< yes!

I would start off by creating a form to gather the information from the different parties, not a form to use, just a form to supply the information so that you can introduce it to your code By way of experiment. Use this information to generate queries that return the number of records you want and basis of forms on these queries.

I would suggest you may need a allocation table, in other words somewhere to store the number of guests each department is allowed to use, not sure.