hi,
i need help im new to access, vba, sql,... and need to adapt this:
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...