Can I update multiple fields in a record

[ogn993160g]

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.

[SioSio]

What is the reason for performing this processing using the API?
And
What language do you want to write your program in?

[Rabbit]

I suspect they posted this in the wrong place and meant to put it in the Access forum.

[ogn993160g]

Thanks you guys problem solved..