Results 1 to 3 of 3
  1. #1
    Tablerone is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    18

    Unhappy Basic help with 2010 code editor please

    Basically I am a non-coder who wants to improve my understanding, but in the short time I need to get by with copy and paste and minor ammendments.



    I used to be quite happy pasting in code like this:
    <Private Sub cboCountry_AfterUpdate() On Error Resume Next cboCity.RowSource = "Select tblAll.City " & _ "FROM tblAll " & _ "WHERE tblAll.Country = '" & cboCountry.Value & "' " & _ "ORDER BY tblAll.City;"End Sub>

    into the code editor for an AFTERUPDATE event.

    Now though, in 2010 the code editor comes up with a green plus, and I have to pick an option. I am totally stumped. Could someone please help.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,620
    Try:

    "SELECT City FROM tblAll WHERE Country = '" & Me.cboCountry & "' ORDER BY City;"

    Not familiar with the 'green plus' you reference. How is it presented to you?
    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
    Tablerone is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    18
    I should have mentioned that I am using a web database template.

    Unlike desktop databases, when you click the "..." next to after update event it goes straight through to the Macro Builder, where you will see what I mean.

    So how can I enter my AfterUpdate event? I would need one for a cascade combo box series, surely?

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

Similar Threads

  1. Button that open Visual Basic Editor?
    By 95DSM in forum Programming
    Replies: 5
    Last Post: 12-20-2010, 10:40 AM
  2. Word.Basic ToolsSpelling won't work in Access 2010
    By stav.kaufman in forum Programming
    Replies: 6
    Last Post: 11-23-2010, 08:44 AM
  3. Can't see visual basic code
    By Michele Keck in forum Forms
    Replies: 5
    Last Post: 09-29-2010, 11:31 AM
  4. Replies: 0
    Last Post: 04-04-2008, 03:43 PM
  5. Problem when activate the Visual Basic Editor
    By milo in forum Programming
    Replies: 0
    Last Post: 05-21-2007, 09:05 AM

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