troubleshooting Question

Code for greying out the form is not working

Avatar of gigifarrow
gigifarrow asked on
Microsoft Access
5 Comments1 Solution274 ViewsLast Modified:
The greyed out field is based on the model number that is in a drop down box. Once the model number is selected then certain fields are greyed. In my code  I have two model numbers,"A3 BFIST" and  "M2A2" then in the code I have two fields one is enabled based on the model number.

Private Sub Form_Current()

If Model = "A3 BFIST" Then
Me.verification.Enabled = True

'The field you want to keep open
 Me.doorMod.Enabled = False
End If

If Model = "M2A2" Then
'The field you want to keep open
 Me.doorMod.Enabled = False
End If

End Sub
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros