Hi everyone!

I am looking for ability to get New ID which will be automatically assigned to my identity setup field, before I insert record.
basically I need to attach this field to some expression and build it into INSERT command, to provide it to another field.

For example

cStroka = _
"INSERT INTO mOpt (objectname) VALUES ("& MakePrefix() & [new id] &")"
objCommand.CommandText =cStroka
objCommand.Execute