access 2010 vba help

hi,



i need help im new to access, vba, sql,... and need to adapt this:

Code:

---

Private Sub Project_Number_Click()

If Me.Town.Column(2) = "" Or Me.Type.Column(2) = "" Then

Me.Project_Number = ""

Else

Me.Project_Number = Me.Town.Column(2) & "-" & Me.Type.Column(2) & "-" & Me.Form.CurrentRecord

End If

End Sub

---

to actually check for which number to use for that type of project in that town.



so instead of "Me.Form.CurrentRecord"



it should check the "Towns" table where in the "Column(3)" line = "Me.Town.Column(2)" for column in that line = "Me.Type.Column(2)" and add +1



thanks for helping :)

access 2010 vba help