Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2010

    Unanswered: Trouble with combobox

    I have managed to create a database where the user can see the list of data and when you click on the end of the data it would bring up a form with more details. In this new form I have added a combo box with the Main ID so that the user would be able to select the next ID easily. THe combobox works when i load the page by itself, but when I go throught the process of clicking the button, the combo box doesn't work.
    Here is the code for when I click the button to bring the form up as I think there is something there thats causing the problem but I cannot see it

    Private Sub GoToDetail_Click()
    On Error GoTo Err_GoToDetail_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "LeafletDetail"

    stLinkCriteria = "[LeafletID]=" & Me![LeafletID]
    DoCmd.OpenForm stDocName, , , stLinkCriteria

    Exit Sub

    MsgBox Err.Description
    Resume Exit_GoToDetail_Click

    End Sub

  2. #2
    Join Date
    Feb 2010
    can someone please delete one of the duplicated posts by me as I was having trouble at the time as it wasn't loading and wasn't sure if it was working.

  3. #3
    Join Date
    Feb 2010
    also in the list there are 2 text boxes, they show the linking table's autonumber instead of the actually text, how do I change this?

Posting Permissions

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