Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2017
    Posts
    2

    Question Unanswered: Pass the Value from the Combobox to a textBox

    Greetings!

    I am newbie in Ms Access 2010. I have a two form "frmResearch" and "frmAuthor" they are link together by ID. The frmResearch contains the information about the authors research project. and the frmAuthor contains the information about the author. These two forms already populated with some data. I created a combobox, "cboSelectAuthor" in frmResearch and already populated with authors. I created a textbox "txtAuthorFullName" and a command button cmdNewAuthor for new author. The "frmAuthor will pop up once cmdNewAuthor was clicked to enter new Author. With Author_FirstName and Author_LastName Here is my inquiry:

    1. How to pass the value from the cboSelectAuthor to txtAuthorFullName in add new data mode?
    2. How to pass the value of the new author from frmAuthor to the txtAuthorFullName in the frmResearch concatenating Author_FirstName and Author_LastName.

    Hope someone will have a time to look at it.

    Thanks in advance.

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,476
    Provided Answers: 11
    on the onload event of a form

    me.feildname = formname!feildname

    ask google about

    me.NewRecord

    and me.dirty

    that should point you down the right road
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  3. #3
    Join Date
    Feb 2017
    Posts
    2
    Quote Originally Posted by myle View Post
    on the onload event of a form

    me.feildname = formname!feildname

    ask google about

    me.NewRecord

    and me.dirty

    that should point you down the right road
    Sorry I'm a little bit confused.
    I already have data in my textbox and it has a control group. When the user add a new data in frmResearch. The user will select in the Authorcombobox. And will pass the value to the authortxtbox (not unbound, with control group)
    If the Authors name couldnot find in the list. Will click the new Author(command button) and will pop up the form 2 "frmAuthor. To type the first name and last name of the author and will click OK. After clicking OK button. It will concatenate firstname and lastname and will pass the value to the authortxtbox.

    Please let me know if explain it clear.

    Thanks,

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
  •