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 Mileage-Expense-Filed-example.jpg
”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
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.