Ask Your Question
0

how to set a default value for a field

asked 2019-01-30 05:36:30 +0200

dougmn gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-01-30 06:35:11 +0200

Ratslinger gravatar image

Hello,

This can be done in the controls' properties under the General tab as Default selection:

image description

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:

image description

and stores the value of 3 in the record if nothing else is selected.

edit flag offensive delete link more

Comments

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.

dougmn gravatar imagedougmn ( 2019-01-30 16:50:58 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-01-30 05:36:30 +0200

Seen: 252 times

Last updated: Jan 30