Not sure if thats a good title.
What I am looking to learn how to do is a selection of a drop-down menu that will populate several other fields whenever a selection is made. Or how to auto-populate text field(s) based on a dropdown list or combo box selection.
Before I come here for help I search diligently for a solution trying to discover it myself. I have searched for this for a long time now and there are vague and various (vba and non) solutions that I just don’t know how to incorporate into my needs now and in the future.
I don’t think it’s so important to find out what exactly im trying to do because I have found the need for this solution many times and will continue to do so. But for now I have a form to populate a budgetEntry table. There’s are various budget “items” such as tractor, irrigation, transplant, fertilizer and so on. There are various orders associated with those item “types”. What Id like to do is have the user select a “budgetType”, say “transplant” for example, and that combo box selection yields a “transplant” query result in the next field which is essentially a query of transplant orders or items to select from. I have the query, I just want to ability for user’s to start by selecting budget type and their next series of choices is based off that type, or keyword/tag (bad way to put it in db language).
How do I do this? Moreover, what is a good desitnation to archive so I can have the steps in doing this in the future.
ap uk fourms is an awesome resource and I learn much here. Thank you ahead of time.
What I am looking to learn how to do is a selection of a drop-down menu that will populate several other fields whenever a selection is made. Or how to auto-populate text field(s) based on a dropdown list or combo box selection.
Before I come here for help I search diligently for a solution trying to discover it myself. I have searched for this for a long time now and there are vague and various (vba and non) solutions that I just don’t know how to incorporate into my needs now and in the future.
I don’t think it’s so important to find out what exactly im trying to do because I have found the need for this solution many times and will continue to do so. But for now I have a form to populate a budgetEntry table. There’s are various budget “items” such as tractor, irrigation, transplant, fertilizer and so on. There are various orders associated with those item “types”. What Id like to do is have the user select a “budgetType”, say “transplant” for example, and that combo box selection yields a “transplant” query result in the next field which is essentially a query of transplant orders or items to select from. I have the query, I just want to ability for user’s to start by selecting budget type and their next series of choices is based off that type, or keyword/tag (bad way to put it in db language).
How do I do this? Moreover, what is a good desitnation to archive so I can have the steps in doing this in the future.
ap uk fourms is an awesome resource and I learn much here. Thank you ahead of time.
