Hi there,

I have the following code.

Code:
  strSQL = "Insert Into tblTicker(CompanyName,Ticker,Exchange,Exchange1,Exchange2)"
    strSQL = strSQL & " Values ('" & Me.CompanyName & "', '"
    strSQL = strSQL & Me.Ticker & "','" & Me.Ex1Text & "','" & Me.Ex2Text & "','" & Me.Ex3Text & "')"
    DoCmd.RunSQL strSQL
    
   
    
    MsgBox "New company has been added"
    Me.CompanyName = ""
    Me.Ticker = ""
    Me.Ex1Text = ""
    Me.Ex2Text = ""
    Me.Ex3Text = ""
You can clearly see what I am trying to do. I insert the data (which works fine) then I want to clear out the textboxes however I get an error - it says...



What I don't understand is how is it somehow associated with that row now? I come from a C# / Web background and so I don't really understand this so well... If someone can point me in the right direction that would be swell!

Thanks!