Results 1 to 3 of 3
  1. #1
    singrambn@gmail.com is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Apr 2018
    Posts
    1

    Visual Basic Code : cboASPECT: how do I make the appropriate txt appear in the drop down box

    I have written a code as follows:



    Private Sub cboASPECT_Change()
    Me.txtMethodLeSel.Value = Me.cboASPECT.Column(1)
    Me.txtMethodPrime.Value = Me.cboASPECT.Column(2)


    End Sub


    I need to add a line that read as follows

    Me.txtMethodSkinChem.Value = Me.cboASPECT.Column(3)



    BUT

    I cannot remember how to make the txtMethodSkinChem appear in the drop down box within visual basic?

    Please assist

  2. #2
    Beetle is offline Unrelatable
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    Camp Swampy (Denver, CO)
    Posts
    207
    I for one don't understand what you are trying to do here;


    • Why are you using the On Change event? This fires at every key stroke.


    I cannot remember how to make the txtMethodSkinChem appear in the drop down box within visual basic?
    txtMethodSkinChem would appear to be a text box control, and you seem to be asking how you would add a text box control to your combo box control, which doesn't make sense.

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Thanks for that Beetle. Exactly how I read it and was equally bewildered.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Replies: 3
    Last Post: 02-03-2017, 02:37 PM
  2. Visual Basic Code Disappears
    By Anton in forum Programming
    Replies: 1
    Last Post: 11-02-2012, 06:16 PM
  3. Visual Basic Code for If Else
    By Baldeagle in forum Programming
    Replies: 1
    Last Post: 09-14-2012, 08:46 AM
  4. Replies: 1
    Last Post: 06-29-2011, 07:22 AM
  5. Can't see visual basic code
    By Michele Keck in forum Forms
    Replies: 5
    Last Post: 09-29-2010, 11:31 AM

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