Is there a way to set a default value for a field, either in table design or in the design of a form? I enter data for the table via a form. The input for the field I’d like to set a default value for is done via a list box on the form, as it is an integer field linked to a field in another table.
This can be done in the controls’ properties under the
General tab as
This list box is set to display the State and store the ID. So in setting the default to
3, on a new record only, it displays
and stores the value of
3 in the record if nothing else is selected.
Great, a simple solution! I was looking in the data tab for something like that, and didn’t think to look in the general tab.