Forum Discussion
lee5010
Jan 22, 2022Copper Contributor
Access Relationship
How can I set up something where I don't have to keep typing the information over and over? Here is what I am talking about: Entry Title POC Phone Address Mileage I need all of these to be com...
ComputerLearningZone
Jan 22, 2022Brass Contributor
Can you give us a little context? What is this for? Why are you typing the same data over and over again? If the data is coming from, say, a customer, then you would only need to select the customer using a combo box and his info could be copied over or at least referenced by a relationship.
See:
https://599cd.com/RelationalCombo
https://599cd.com/DLookup
https://599cd.com/AfterUpdate
Richard Rost
Access MVP 2014-15
AccessLearningZone.com
See:
https://599cd.com/RelationalCombo
https://599cd.com/DLookup
https://599cd.com/AfterUpdate
Richard Rost
Access MVP 2014-15
AccessLearningZone.com
lee5010
Jan 22, 2022Copper Contributor
I used the basic template in Access called "Desktop Business Account Ledger". In the Entry Title, I put the store Name and I want the POC, Number, Address, and Mileage to autofill when I enter the Entry Title. I hope that this helps you out! Let me know if I need to give you any more information? Thank you