Results 1 to 1 of 1

Thread: [RESOLVED] Set value of textbox from a combo box column

  1. #1

    Thread Starter
    Member
    Join Date
    Feb 2006
    Posts
    50

    [RESOLVED] Set value of textbox from a combo box column

    I am trying to set the value of a textbox named "Address" by referencing the value of column 1 of a combo box named "Location". The following code is not working for me. Please help

    Private Sub Location_Change()
    Address.Value = Location.Column(1)


    End Sub

    I have also tried the following code..

    Private Sub Location_Change()
    Address.Value = [Form]![Location].[Column](1)

    End Sub

    Resolution:
    Private Sub Location_Change()
    Address.Value = Location.Column(1, Location.ListIndex)
    End Sub
    Thank You "bushmobile"

    carbo
    Last edited by carbo; Apr 29th, 2006 at 03:02 PM.

Posting Permissions

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



Click Here to Expand Forum to Full Width