two ways to add item using combobox (1 Viewer)

Hi

its two ways to add data in ms access

see all in youtube

first: using combobox in form to add items

https://youtu.be/Q8iPPJVzMjg
-------------------

secound: using combobox in table to add items

https://youtu.be/XJvEYz2lBt8

Hello and welcome again to AWF. I’m not sure if you are asking a question or not. However, if you are asking if one way is better than the other, then I will tell you adding records with a form’s combo box is perferred.

To have a combo box at the table level requires a lookup field which I NEVER do at the table level.

Combobox at table level does not require the "Lookup" data type. A text or number field can have combobox settings at table level as well. However, I also never set combobox or listbox in table, especially if the 'lookup' has alias (multi-column combobox/listbox). As developer, when I view table I prefer to see real values saved in field. Review http://access.mvps.org/Access/lookupfields.htm