Changing Table Default Values from a Form 1

[BMcMakin]

I have a table that has several default values in it. I would like to be able to modify the default values in a user friendly form instead of having to go into the design view of the table. Is there code that I can use?

 

[PHV]

You have to play with the following DAO objects:
TableDefs, TableDef, Fields, Field.
The basic idea:
CurrentDB.TableDefs("myTable").Fields("myField").DefaultValue = "New default"

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