>If you type procedure name as default field value in table designer (personally, i wouldn't use for primary key generation) then the procedure return value will be used as default value, right?

Yes, right. But I'd also need to show that value on my form...
Your idea to call the procedure from code is right, but suppose that your machine crashes without unlocking the record. What could be done ?