Updating display in a form
So, the design of your form is an important aspect.You can do a lot more things with designing of the form in MS Access.To create a form from a table or query in your database, in the Navigation Pane, click the table or query that contains the data for your form, and on the Create tab, click Form.Access creates a form and displays it in Layout view.
The two views are connected to the same data source and are synchronized with each other at all times.
Forms in Access are like display cases in stores that make it easier to view or get the items that you want.
Since forms are objects through which you or other users can add, edit, or display the data stored in your Access desktop database, the design of your form is an important aspect.
Depending on how database designer sets the lookup field, you can select one or more item from that list.
Lookup field many times confuses the new access users because list of items appears in one location but data can be placed in another location.