Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Problem With Synchronized Combo Boxes (Access 2000)

    (Edited by HansV - queries displayed in table form)

    I'm trying to create a couple of synchronized combo boxes, but I keep getting a parameter box coming up when I open my form, and it's asking for a StudID. Here's how I have it setup:

    Student List query
    <table border=1><td>Field:</td><td>StudID</td><td>FirstName</td><td>LastName</td><td>Table:</td><td>tblStudent</td><td>tblStudent</td><td>tblStudent</td><tr><td>Sort:</td><td align=right>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Problem With Synchronized Combo Boxes (Access 2000)

    Does it help if you change the second query to the following?

    <table border=1><td>Field:</td><td>InvID</td><td>SchoolYear</td><td>[forms]![frmRefund]![Combo9]</td><tr><td>Table:</td><td>tblInvoices</td><td>tblSchoolYear</td><td align=right>

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem With Synchronized Combo Boxes (Access 2000)

    Nope, it doesn't make any difference. <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Problem With Synchronized Combo Boxes (Access 2000)

    Try this then:
    - Open the form in design view.
    - Clear the Row Source of Combo15.
    - Change the After Update event procedure for Combo9, substituting the correct name

    Private Sub Combo9.AfterUpdate()
    Me!Combo15.RowSource = "Exact name of invoice list query"
    Me!Combo15.Requery
    Me!Combo15.SetFocus
    End Sub

    Tip for future development: I recommend giving controls meaningful names. If you have to perform maintenance on the database after months of not working with it, a name such as cboStudentList or cboInvoiceList is much easier than Combo9 or Combo15. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Problem With Synchronized Combo Boxes (Access 2000)

    Well, it's finally working. I finally figured out what my problem was. I still had remnants of a subform still on my form. That's why it was wanting that parameter. <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

    I also took your advice on naming controls. I guess I was just concered with trying to get it to work, than with the names. Thanks.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Problem With Synchronized Combo Boxes (Access 2000)

    Glad you found it! This kind of thing can be hard to trace. <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>

Posting Permissions

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