I'm not sure how what you ask is possible considering the nature of forms, but you can try the following alternative:
(1) Create table Services:
Service_Id (Autonumber (can as well be entered by user), Primary Key)
Group_Id (Number) or (Text)
Service_Name (Text)
each record will have a service name and its apropriate service group
(2) Create table Selection:
Selection_Id (Autonumber (can as well be entered by user), Primary Key)
Selection (Text), you can also make it a Combo Box in Lookup, and make its Row Source:
SELECT Services.Service_Name, Services.Group_Id FROM Services
with Column Count of 2 for looking up for all possible serivices from Services table, but it is not nescasary for the form.
Add all the other fields you need for creating selections in the form, ex:
Field3
Field4
(3) Create query qrySelection:
SELECT Selection.Selection, Selection.Field3, Selection.Field4, Services.Group_Id
FROM Selection LEFT JOIN Services ON Selection.Selection = Services.Service_Name;
Save it.
(4) Create a continuous form myForm based on qrySelection:
On form's header or footer add a Combo Box named cboGroup_Id with the following Row Source:
SELECT DISTINCT Services.Group_Id FROM Services;
Put Selection field control and Group_Id field control and all the other necessary field controls into detail section. Change Selection control (if it is not already) to Combo Box, with the following Row Source:
SELECT Services.Service_Name FROM Services WHERE (((Services.Group_Id)=Forms!myForm!cboGroup_Id));
Add
to cboGroup_Id On Change event.
---
Now the form should work by user choosing the Group_Id from cboGroup_Id having the appropriate service names on the rows and the service groups according to them.
35
