Results 1 to 3 of 3
  1. #1
    DallasW is offline Novice
    Windows 8 Access 2013
    Join Date
    Feb 2015
    Posts
    8

    Populating a text box from selection from combobox

    I am having problems population a textbox (Next Corrective Action) from selection in combo box (Corrective Action).


    In the textbox, After up Event code I am using.

    If Me!CorrectiveAction.Value = "Verbal Warning" Then
    Me!NextCorrectiveAction.Value = "First Written Notice"
    End If
    If Me!CorrectiveAction.Value = "Written Warning" Then
    Me!NextCorrectiveAction.Value = "Final Written Notice"
    End If
    If Me!CorrectiveAction.Value = "Final Warning" Then
    Me!NextCorrectiveAction.Value = "Release from Assignment at VMC (Next infraction will result in EOA)"
    End If

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Quote Originally Posted by DallasW View Post

    ...In the textbox, After up Event code I am using...
    Your code needs to be the the AfterUpdate event of the Combobox...not the Textbox.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    above advice plus you don't need .value

    If Me.CorrectiveAction = "Verbal Warning" Then
    Me.NextCorrectiveAction = "First Written Notice"
    End If

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

Similar Threads

  1. Replies: 7
    Last Post: 05-12-2014, 06:05 AM
  2. Replies: 2
    Last Post: 05-08-2014, 01:51 PM
  3. Populating Text box after selection from Combo Box
    By coach32 in forum Programming
    Replies: 3
    Last Post: 03-19-2014, 10:15 PM
  4. Replies: 9
    Last Post: 01-17-2013, 09:08 PM
  5. Populate a text box based on a combobox selection?
    By Richie27 in forum Programming
    Replies: 4
    Last Post: 04-25-2012, 08:00 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