Results 1 to 3 of 3
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    2,095

    Combo box unresponsive

    I have a combo box whose row source is a query. The display is correct when I click the drop-down arrow, but I can't get any response when I click on an item in the list. I put a debug stop in the OnClick Event Procedure, but the event never fires.

    The combo box is located in the Header Section of a continuous form. The intent of the combo box is to allow the user to select an amount from the list and have the OnClick Event set the filter of the form to limit the display to the amount indentified. Simple enough, but I can't get the click action to respond.


    Click image for larger version. 

Name:	cboData.jpg 
Views:	7 
Size:	53.7 KB 
ID:	19448Click image for larger version. 

Name:	cboFormat.jpg 
Views:	7 
Size:	103.1 KB 
ID:	19449Click image for larger version. 

Name:	cboEvent.jpg 
Views:	7 
Size:	60.2 KB 
ID:	19450Click image for larger version. 

Name:	cboOnClick.jpg 
Views:	7 
Size:	18.7 KB 
ID:	19451

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Is the form bound to an editable query?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    2,095
    The query itself is, but the four text box controls of the continuous form are not.

    The query:
    SELECT DonRegFam.DOE, Families.FamilyName, Funds.FundID, Funds.FundTitle, DonRegFam.Amount
    FROM Funds INNER JOIN (Families INNER JOIN DonRegFam ON Families.FamilyID = DonRegFam.FamilyID) ON Funds.FundID = DonRegFam.FundID
    ORDER BY DonRegFam.DOE;

    The Data properties of the form: I had disallowed edits on the forms data. As soon as I changed that to "YES" everything worked as expected. I'll "Lock" against edits at the text box level to essentially accomplish what's needed.

    Click image for larger version. 

Name:	FormData.jpg 
Views:	7 
Size:	44.3 KB 
ID:	19452

    Thanks,
    Bill

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access Unresponsive
    By ajs112 in forum Access
    Replies: 2
    Last Post: 01-13-2015, 04:25 PM
  2. Replies: 2
    Last Post: 10-21-2014, 07:57 AM
  3. access unresponsive
    By joanne21 in forum Access
    Replies: 3
    Last Post: 01-17-2013, 07:05 AM
  4. Interface unresponsive after query is run
    By outlier in forum Access
    Replies: 2
    Last Post: 04-03-2012, 12:15 PM
  5. Replies: 4
    Last Post: 08-16-2011, 05:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums