I have a data entry form in a database and I'd like to make certain fields in the form unavailable depending on the criteria in one of the fields.
Example: In my company we have different systems used in different offices. My database stores employee details for people in all offices. Some of the details won't be relevant to certain people, but the data entry form shows all fields, relevant or not. I'd like to disable the irrelevant fields.
Something like: If [Location] = Nottingham Then (code to disable the irrelevant field would go here)
Hope that makes sense.
Example: In my company we have different systems used in different offices. My database stores employee details for people in all offices. Some of the details won't be relevant to certain people, but the data entry form shows all fields, relevant or not. I'd like to disable the irrelevant fields.
Something like: If [Location] = Nottingham Then (code to disable the irrelevant field would go here)
Hope that makes sense.