Results 1 to 3 of 3

Thread: list box error

  1. #1
    Join Date
    Mar 2004

    Unanswered: list box error

    I have this code on double click from a list box to open the edit form:

    Forms!frmEdit.pgInventory![CategoryCode].Value = Me.lstList.Column(2, A)

    when I double click the list box I want to open the form edit to the selected list, but I am getting this error message "Object doesn't support this property or method". What is wrong?

  2. #2
    Join Date
    Nov 2003
    Forms!frmEdit.pgInventory![CategoryCode].Value = Me.lstList.Column(2)


  3. #3
    Join Date
    Mar 2004
    Still did not work? Here is the rest of the code:

    Private Sub lstList_DblClick(Cancel As Integer)
    For A = 0 To Me.lstList.ListCount - 1
    If Me.lstList.Selected(A) = True Then

    DoCmd.OpenForm "frmEdit"

    Forms!frmEdit.pgInventory![CategoryCode].Value = Me.lstList.Column(2, A)

    End If
    End Sub

    It works on some part of the form when it is not in the tab control of the forms? I guess how do you reference a textbox in a tab control from the form?


Posting Permissions

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