In one of my columns in a DBGrid, I need to place a Default Value. The default Value is under the Columns, Default Value property, however, when adding a new record, the default value is not inserted into the column.
The DB is tied to an Access table, and the field in Access has no default value..as it shouldn't. It is important that I NOT set it there, as the default value might change in each form in VB. ie Contractor Form, default value "Contractor", Main form, default value "Primary".
Additionally, I need to validate or give an option group to have my choices for this column(6) in my DBGrid to have the choices of : Primary, Contractor, Sub-Consultant, Outside-Associate or Partner. Can I build this into my DBGrid?