Updating edgar access codes Live chat sek
If the query for the lookup list is based on a table, you identify that table and the field that contains the data that appear in the list.You then open the source table and edit the data in that field.A combo box opens to present the list, and then closes once you make a selection.A list box, by contrast, remains open at all times.In turn, those design principles affect how you enter data.
In a Table You can validate data in Access desktop databases as you enter it by using validation rules.
For more information, see Create a list of choices by using a list box or combo box.
By default, Access provides a built-in form for the purpose of editing the value list.
If the query for the lookup list is based on another query, you must open that second query, find the source table and field from which the second query takes its data, and change the values in that table.
The data type that you set for each table field provides the first level of control over what type of data is permitted into a field.