Results 1 to 5 of 5
  1. #1
    Khalil Handal is offline Competent Performer
    Windows 10 Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    237

    asign a value to a combo box when open form

    Hi to all,


    I have a form with a combo box, I have a function to be executed when double click on the combo box, this function opens a second form with an other combo box on the second form. How can I assign the value of the combo box of form1 to the combo box on the second form?

    Any help is appreciated
    Khalil

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,860
    You can pass it in via OpenArgs (which is how tended to do it) or you can assign it directly via form control syntax, after opening the form.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Khalil Handal is offline Competent Performer
    Windows 10 Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    237
    Hi,
    More details please, Not very much familiar of using OpenArgs

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,860
    Quote Originally Posted by Khalil Handal View Post
    Hi,
    More details please, Not very much familiar of using OpenArgs
    Google OpenArgs then.
    Could also google 'set access control from another form'?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    Khalil Handal is offline Competent Performer
    Windows 10 Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    237
    Hi,
    I passed it directly after opening the form.
    Thank you very much

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

Similar Threads

  1. Replies: 4
    Last Post: 05-11-2020, 10:42 PM
  2. Combo Box to Open a New Form
    By sud2017 in forum Forms
    Replies: 3
    Last Post: 07-18-2017, 02:18 PM
  3. Replies: 22
    Last Post: 05-10-2014, 04:43 PM
  4. Open form from combo box
    By aceoftrades in forum Access
    Replies: 31
    Last Post: 03-05-2012, 06:02 PM
  5. A Combo box that open another form
    By mar_t in forum Access
    Replies: 14
    Last Post: 01-09-2011, 10:53 PM

Tags for this Thread

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