You will have to provide much more information. Why is this a vba problem and not a query problem? Does Field03 exist in the table? Why should each combo value go into the table in the same order as you are showing (there doesn't seem to be any relationship between any combo and any particular date or name). You have not really named things as you are showing??
This looks like pseudo data (something made up that doesn't really represent the real situation).
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
This is not a code issue; it's a query issue. Query language (sql) is not code. I'm not understanding why you keep asking about code.
Using the design tools from the Ribbon Create tab,
- create your table.
- create a select query based on the table (include all the table fields you need)
- open the query in datasheet view
- if you can enter valid data in all your query fields, then create a form based on this query and add your data through the form
Based on the (still) scant information you've provided, I see no reason for a combo box versus a text box, but if you know how to bind a combo to a table AND create its row source, then by all means, do so if that's what makes sense. ***What doesn't make sense*** - having a different combo box for each of 20 records for one field. 20 combos would be 20 fields, not records.
The meaning of that statement is still unclear. I/we are supposed to guess what field name? What number? I can't help if you can't provide enough information. Not much of this is making sense.i don't how to write a code using loop field name + number adding a record