troubleshooting Question

Help with MS Access-2010 VBA (Or Macro)- Allow user to populate form field based on entry into another form field

Avatar of TonyMannella
TonyMannellaFlag for United States of America asked on
Microsoft OfficeMicrosoft AccessMicrosoft Applications
2 Comments1 Solution566 ViewsLast Modified:


Access 2010

I'm currently developing a time/Expense system in an access database.  What I am trying to do is provide the user the ability to populate a form field if and only a prior form field is populated with the correct data.

I have two fields on my Expense form - 1 is a Expense code ID and the other is Mileage.  What I want to do is if the expense form field has an expense ID related only to mileage (text string is Mileage),  then and only then can they input the mileage amount but cannot enter anything in the Expense amount form field.  And, vice versa, if the user enters the mileage (it auto populates the mileage amount based on an calculation), then they cannot enter anything in the Expense Amount field.  See screen shot attached.  Any help would be appreciated

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 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 2 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