Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Oct 2004
    Location
    Minnesota, USA
    Posts
    151
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cascading Combo Boxes (Office 2003)

    Attached is a file with another form in the tickler database you helped me with last week. This form has two combo boxes and a subform to update the status of the information being tracked that was input in last week's form.

    I have the two combo boxes talking to each other. I cannot, however, get the subform to update based on what was selected in the second combo box.

    Any suggestions?

    Thanks for all your assistance.

    Nancy
    Attached Files Attached Files

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

    Re: Cascading Combo Boxes (Office 2003)

    1) You have declared a parameter assn in the query qselAssociationReports. You should remove this (in Query | Parameters).
    2) You have set the Link Master Fields property of the subform to cboReportTitle,cboReportTitle. This should be cboAssociation,cboReportTitle.
    3) The Bound Column of cboReportTitle is 2, but the Columns Count is 1, so there is no second column. You should set the Bound Column to 1.

  3. #3
    2 Star Lounger
    Join Date
    Oct 2004
    Location
    Minnesota, USA
    Posts
    151
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cascading Combo Boxes (Office 2003)

    Thanks, Hans. I appreciate your quick response.

    Nancy

Posting Permissions

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