That's cool :) Not meaning to rain on your parade, I would change your variable from Other to NewSector just for clarification purposes and to avoid confusion from:
So, change to:
NewSector = "Other"
Then your statement would be:
DoCmd.RunSQL "INSERT INTO Industry_sector(industry,sector) Values('" & NewInd & "', '" & NewSector & "' );"
PS A sliver isn't necessarily a bad thing. It means you've been crafting something by hand :D