Let's make clear:
A) you want to override the value that would be generated with a value coming from elsewhere?
Sorry, but you can't do that in access
B) you want to make the number generation to work?
In this case you simply have to omit totally that field from the insert statement.