Set a default on the fly

[Thompyt]

How would I set the default value on a table from a form with a combo box? I have pre-defined values I want in the list


Form!Settings.Type Row source: Text values

I would like to change the default value in the table Table_Name.Type on the fly by using the form and not having to have to go into the table and edit the controls manually.



Thanks

[CJ_London]

in the relevant form control properties, just set the default value to what you want. Note this will not be assigned to a new record until the record is saved - and will not be applied to blank fields in existing records

[Thompyt]

Ajax,
Not tracking. I have:

Form = Settings
Form Record source = SELECT DISTINCT [Changes].Type;

ComboBox
Control source = Type
Row Source = "Choice 1";"Choice 2";"Choice 3"
Row Source type = Value List
Bound Column = 1

I run the form and I can drop to see the choices, but cannot select.

This would write to the table?

[CJ_London]

1. type is a reserved word so change it to something else (e.g. ChangeType) and see if that solves the problem
2. your form recordsource is incomplete - needs a 'From sometable'

[Thompyt]

Changed it to Types

SELECT DISTINCT [Changes].[Types] FROM [Changes];

Same issue

Update
I restarted and made a new form - I can select them and they stay and I can select the icon to set Default. But it does not write to the field in the Change Table when I open another form to input data. Am I supposed to link that field from the Settings form for any other form used?

This would also be defeated by importing data from another source?

[CJ_London]

and you corrected the combo as well?