Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2014

    Unanswered: Problem Solving: Combo Box / Query has stopped working

    I have a split form for a query. The split form has multiple combo boxes. The query criteria reads:

    Like "*" & [Forms]![Main_F2]![cboRMStatus] & "*"

    The combo boxes have an "After Update" event to requery the query.

    One combo box has stopped working. After updating it gives me a zero result. I cannot seem to figure out what happened!

    I did delete a record in the underlining table and updated some info. Any suggestions?


  2. #2
    Join Date
    Apr 2014
    Provided Answers: 23
    Not from these scant details, but Is it possible there are > 1 combo interfering in the query?
    Did you try each combo 1 at a time if it works?

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    if you deleted the underlying table or query you will need to redefine the combo's rowsource(s). Although Access odes a pretty good job of housekeeping when you rename stuff it does trip up and always trips up when you delete tables or queries or columns within

    but you will need to investigate
    are you gettign some data in the combo
    is it the data thats missing
    is it code runnign whne you do soemthign thats missing
    have you put a breakpoint on the relevant events and then stepped through the code to see what ACTUALLY happens as opposed to guessing or gettign frustrated becuase tis not working. Access has a fantastic IDE and debugger, use it
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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