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.
Hello,
This can be done in the controls’ properties under the General tab as Default selection:
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 Il:
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.