Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2008
    Posts
    150

    Unanswered: Auto-Populate Text Field after combo box item selected

    Hello,

    I need to auto-populate a text field called “Date_Issue_Resolved” when a user selects the item “Resolved” from a combo box called “Issue_Status”.

    My items in the combo box are Open and Resolved. I am using Access 2010.

    Any help is appreciated.

    Thank you.

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Where does the data for “Date_Issue_Resolved” come from?
    Have a nice day!

  3. #3
    Join Date
    Sep 2008
    Posts
    150
    It is in the "Row Source Type" Value List.
    Row Source: Open;Resolved

  4. #4
    Join Date
    Sep 2008
    Posts
    150

    Code size of Dialog form

    Hello,

    Is there a way to open a form in the width and height I specify when I click on a button?

    I would like my dialog form to open in 3x5 size. Can I do this in some type of code or macro?

    Thank you in advance. :-)

  5. #5
    Join Date
    Sep 2008
    Posts
    150
    Sorry Sinndho, I was trying to post my other issue as a new post and it attached to this message. :-(

  6. #6
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Assuming you want to populate Date_Issue_Resolved with the current date, when 'resolved' is selected:

    Code:
    Private Sub Issue_Status_AfterUpdate()
      If Me.Issue_Status = "Resolved" Then
        Me.Date_Issue_Resolved = Date
      Else
        Me.Date_Issue_Resolved = Null
      End If
    End Sub

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  7. #7
    Join Date
    Sep 2008
    Posts
    150
    THAT IS IT!

    Thank you Missingling. :-D

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •