Results 1 to 8 of 8
  1. #1
    AccessForumUser is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jun 2017
    Posts
    19

    Help in exporting combo box results

    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!

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Could you pass the combobox results using openargs?

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    It depends on the main form record source. The combo boxes ROW source should be the same... are the combo boxes CONTROL source in the main form record source?
    You would/might also have to copy/paste the code attached to the combo boxes.



    Consider attaching your dB for analysis.......

  4. #4
    AccessForumUser is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jun 2017
    Posts
    19
    Here's the DB.. I'm making a very simple database to basically track cell phones by make and model. I have only populated Apple phones, and one Samsung to test with..
    I would like to have one form with the drop down cascade boxes to record the results.

    Thanks again.
    Attached Files Attached Files

  5. #5
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Main form is bound to main table, each object on the main form that comes from this table will have its Control Source property set to the field that is on the main table. Each combobox will have a row source coming from its table with the control source set to the field name on the main table (model is missing).

    PK's belong to tables, not to forms.

    You can copy and paste the two comboboxes on to the main form as they are both working the way you want, just add the control source.

  6. #6
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I don't like the way the video designs the cascading combo boxes.

    Play with this example - see if this is close....
    Attached Files Attached Files

  7. #7
    AccessForumUser is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jun 2017
    Posts
    19
    ssanfu, I can't thank you enough for this. I really appreciate the time you spent tweaking this for me. This is exactly what I was working towards..
    I would like to also thank everyone else who contributed to this post! I've tweaked my database based on your suggestions and comments.
    keep up the good work, there's no way I could have done this myself. great community, thanks again!

  8. #8
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    You are welcome. Sometimes it is easier (at least for me) to be able to tear apart an example and learn from it.


    Would you consider this solved? If so, see the top header "How to Mark a Thread Solved".

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Macros for exporting search results into excel?
    By Mahendra1000 in forum Access
    Replies: 1
    Last Post: 10-09-2015, 06:52 AM
  2. Exporting filtered results to Excel
    By doublec9 in forum Import/Export Data
    Replies: 2
    Last Post: 06-04-2013, 09:05 PM
  3. Replies: 3
    Last Post: 02-09-2013, 09:23 PM
  4. Exporting Query results to Excel with VBA
    By Tomlon in forum Programming
    Replies: 1
    Last Post: 01-29-2013, 09:56 PM
  5. Exporting Query Results to an existing Excel Workbook
    By Dnphm in forum Import/Export Data
    Replies: 3
    Last Post: 07-13-2010, 11:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums