Find and Edit Records via Form

[Jonbob]

I have a userform where people enter data based on 6 bounded combo boxes and 12 (monthly) open text boxes. The 6 bounded combo boxes make up the primary key.

I am looking for a way to allow a user to choose a key using the combo boxes, retrieve the record, and update the monthly fields.

 

[Joe4]

How comfortable are you in writing VBA for Access?

Basically, the process here is to use the Combo Box entries to build an SQL statement to create and run the query with that criteria. I often you the Query builder to build what each part of the query should look like (go to SQL view after you build it), then recreate it in VBA to build that statement in SQL.