Disabling Certain Fields on a Data Entry Form

[Fritz24]

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.

 

[caringsharingbristolbilly]

I've had to do something similar, and the best way I've found is to simply make the no-longer-required fields vanish.

So, something like (using your example and Systemname as one of the fields you want to hide):

If Location = Nottingham Then
Me.Systemname.Visible = False

This means that they won't even try to enter data in. You could also use (and I think this is right)

Me.Systemname.Locked = True

But if you use the second method and your staff are anything like ours, you'll get people asking you all the time why they can't enter data in those fields!!

HTH...

 

[Fritz24]

Lordy that's hideously simple but does the job spot on.

Many thanks for your help!

 

[caringsharingbristolbilly]

Glad to have been of assistance. I think it's the first time I've actually managed to help someone properly!!

I'm a real access newbie, so I feel a little less guilty about taking so much help while giving so little back now...!