Basic help with 2010 code editor please

[Tablerone]

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.

[June7]

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?

[Tablerone]

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?