How to modyfy field property in a linked table?

[Vard]

I need to set the default value of a field to 0 in a linked table, but it says, "you cannot modify it".

Could anyone tell me the steps so that I could modify the the initial value and also keep the links?

Thanks
Vard

 

[PHV]

You can't modify the default value on the table level.
Simply do it in the form level.
I presume that nobody creates record at the table level, isn't it ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Vard]

Thanks for your answer.

The problem is that in the VB code there is a statement which uses IF NOT(...empty...) and the field should have a value in order to proceed. In the other fields the initial value is just set to 0 and it works. Only in one of the tables the same field is empty and it just needs to have an initial value, 0. The table is linked and no modification is allowed. this is the proble.

Thanks again for any help from anyone.

 

[PHV]

Have you tried the IsNull function ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244