Default value

[Originally posted by Johm]


Default Value

I want to change the default value of the field Quantity from 1 to 0 with the following command:
CurrentDb.TableDefs("order details").Fields("Quantity").Default = 0

but i receive the messageÿ " method or data member not found "

Also the same filed has a Validation Rule > 0. How can i delete this requirement?

How can i correctÿ my command?

Of course i could do it by opening the database in design view,nothing simpler than that, but i need to send this command
to a person in another town, whi has no direct access to the table