Curious how to use a form to make data entry easier (1 Viewer)

I am currently creating an Access database that contains:
- a table with vendor information
- a table that has generalized products within
- a table that connects which vendor has which product(s) (many to many)

I am trying to use a form to make entry easier and faster.
I was curious if there was a way to:
- Enter in the vendor and have them stay when doing multiple entries
- Enter in the general product, but having the field return to blank after pressing enter.

Yes, this can be made simple with a subform. The main form is based on the table on the "one" side of the relationship and the subform is based on the table on the "many" side of the relationship.

Since you have a many to many this means you can add data to the VendorProducts table in two manners:

~Main form based on Vendor table and then a subform based on VendorProducts where Vendor is held constant (in main form) and you select a product in the subform.

~Main form based on Product table and subform based on VendorProducts where Product is held constant (in main form) and you select a Vendor in the subform.

Check this link out for details:

https://support.office.com/en-us/ar...any-form-ddf3822f-8aba-49cb-831a-1e74d6f5f06b

Hi. Welcome to the forum!