Hello, I am wondering how I can take two combo box results and display them in another form, OR somehow combine two forms into one. I would like to have the combo boxes included in my main form is where i'm going with this. currently they are in another form outside my main form.
I have basically done what this video has shown me, and the combo boxes have worked perfectly. https://www.youtube.com/watch?v=3ljoKaS6M9Q
My problem is that I would like to take those combo boxes and include them in my main form, record the results along with a bunch of other inputs and checkmark boxes. I'm facing the problem of having my main form as a PK to record entries, and my combo box form also has PK assigned..
Both forms have PK's associated to them..
I'm not sure which path is needed to accomplish this. my thoughts are:
1. drag and drop the combo box form into my main form, resize it, and clean it up so it's consistent with my other input entries, not ideal, but just my thoughts..
2. open the combo box form and drag and drop the two entry fields from that form into my main form to make it consistent with the rest of the entries?
3. try to remake the combo boxes into my main form.. might be easiest.. not sure. just don't want to mess up my main form
Problems i see..
I don't know where to start with taking the results from the combo boxes and adding them into my main form.. is it a control source option?
If anyone has some suggestions or ideas, let me know.. This doesn't sound complicated to me, but I just don't have enough experience with access to figure out the right steps to take..
Thanks!