MS Access: Problem with default value

[scrubz]

I'm trying to use a default value in an MS Access field that adds 1000 to the orderID field. So, the default value would be... =[orderID]+1000

But I get an error that "the database engine does not recognize either the 'orderID' in a validation expression, or the default value in the table CUSTOMER."

As far as I can tell, the syntax is correct. What am I missing?

[compwizard]

I don't think you can reference another field name inside a default value field. Perhaps you can use an update query to accomplish the same effect.

[scrubz]

Bummer. Yeah, I thought about an update query. I was hoping to avoid two calls to the database, but I guess that's what will happen. Thanks.

[compwizard]

don't hesitate to ask if you need help with the update query okay!!