Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Location
    Edmonton, Canada
    Posts
    72

    Unanswered: Access ComboBox Won't Populate

    I'm using SQLServer2000/Access 2000 .adp. The .adp has a form with 2 combo boxes. The 1st combo box is bound to a stored procedure and loads fine when the form loads. I then set the 2nd combo box's RowSource passing the value of the first into the stored proc:

    Me.secondComboBox.RowSource = "EXEC dbo.proc_My2ndProc '" & Me.cboFirstComboBox & "'"
    Me.cbosecondComboBox.reQuery

    Why won't it work? I've set a form's RecordSource using this methof, and it works great???

    Thanks,
    Carl

  2. #2
    Join Date
    Jul 2004
    Location
    Edmonton, Canada
    Posts
    72
    Dummy me, I didn't have the RowSourceType set to Table/View/StoredProc, all's well. I figured it out by creating a new form, and it was working, so I went to see what was different.

Posting Permissions

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