Can I update muiltiple fields records in a table using a form?

[ConstructionGirl]

Hello! Help please! I am trying to create a user friendly database for use with our construction company. I am trying to create a form (which seems to be the most user friendly) that pulls existing records and updates fields on the table based on the record found. See below...

ID - (Auto numbered - identifies the existing record)
Field 1 - Step 1 - Search existing records using this field.


Field 2 - Step 2 - Auto populates based on the existing record. If duplicate Field 1's are found, there will be a drop down to select the correct record by the text in Field 2.
Field 3 to Field 8 - Step 3 - All these fields auto populate based on selected record from Steps 1 & 2 in order to update the record. If no data exists, use the form to add data and update existing record.

[June7]

Are those search controls UNBOUND?

Perhaps you need to set up second combobox as cascading - values in list are dependent on selection in first combobox. This is a very common topic and many threads and examples.

Fields 'autopopulate' by simply going to desired record when using BOUND form and BOUND controls.

Options for finding and 'going' to desired record.

1) use intrinsic filter/search tools on ribbon and right click menu

2) several methods in VBA - here is one http://allenbrowne.com/ser-62.html

What have you attempted, if anything?

[ConstructionGirl]

Thank you so much for pointing me in the right direction. I don't know any of the correct terminology, so this really helps narrow it down!

I only made that example form to markup and get help to make it work the way I imagine. Thank you again!