Best way to design a form

DBL

Registered User.
Local time
Today, 18:39
Joined
Feb 20, 2002
Messages
659
Just wondered if anyone had any suggestions. I have a subform with a drop down list of requirements. Every client needs to have a response against all the requirement options but I don't want to hard code the requirements into a table and form as the options will change or be added to. So bascially I don't want to have a form with fixed fields that I keep having to update the form.

Is there a way to keep the list dynamic but still have all the options listed to be completed, rather than the user having to select each and every option from a drop down list for every client?

Hope that makes sense!
 
Sounds like you need another subform there that will list all the growing/changing list of requirements with a Yes/No field indicating whether that requirement has been completed or not. The subform will be linked to your other subform via the ClientID.
 

Users who are viewing this thread

Back
Top Bottom