I understand this.
This can obviously be done with the combo box, right?
Now, that underlined portion, I am not following at all. And I'm certain, that is the most important part. Got any more detail in the explanation bank?
I do not know how the underlined portion is related to the first part of the quote. I'm at a loss with that. So YES, I need more...
At least one WHAT? Record? Go ahead and shoot me, but that's not specific!!
All 5 WHAT? Records? Combo Boxes? If you meant Boxes, there are only 3 boxes on the form, Ray.
.
I completely understand this part. It's quite obvious that there is an uncertainty here of how many records are going to entered; 1, 2, 3, 4, or 5. And I know you want to eliminate redundancies, and data entry, but if you don't mind, could you answer the specifics above? Thanks!
at least one combo box filled in, which will apply to one record. and you will have to forgive me, im not feeling very specific today...Ray,
It's obvious that from the snapshot, the form is based entirely on one table. Now, maybe you should know what your words are really saying to me...At least one WHAT? Record? Go ahead and shoot me, but that's not specific!!
As of now, and that photo, i dont have all 5 combo boxes on the form, you are correct. at least one combo box has to be filled in which relates to one record. if 5 comboboxes are filled in. there will be 5 records createdAll 5 WHAT? Records? Combo Boxes? If you meant Boxes, there are only 3 boxes on the form, Ray.
.I completely understand this part. It's quite obvious that there is an uncertainty here of how many records are going to entered; 1, 2, 3, 4, or 5. And I know you want to eliminate redundancies, and data entry, but if you don't mind, could you answer the specifics above? Thanks!
now we are getting somewhere!! 
Well Ray, I guess I can say that this really doesn't make much sense!!
Why in the world would you want to go through the multiple-record entry process this way!? Are you aware that each of the combo boxes in that picture pertain to different values in a single record?? Can you tell me what sense you can make out of someone selecting a caseID, AND an expense type, AND a payment method, and then using that fact (the fact that someone selected values from 3 boxes) as criteria for saying, "OK, this tells me that 3 records need to be entered". I would sure like to hear an explanation of THAT!! Please...tell me I'm wrong about my assumption here! And if I have no ***** clue about your problem, tell me, so I don't confuse you any more.
Well Ray, I guess I can say that this really doesn't make much sense!!
Ray, obviously this can be done through a recordset nav., but the question is how you want to do it. Couldn't you possibly just send the 5 combos to an array and ".AddNew" based on a conditional "IsNull" for the elements?
!! thats why i was asking! point me in the right direction!???!??!??!
I tried to think how you could do this, but it is tough. You might want a different structuring of the form. That might eliminate some of the headache. To get started though, maybe you could throw each control value to a variable before you add a new record??...perhaps, but like i said, i dont know recordsets!!
dim x, y, z
x = me.control1
y = me.control2
z = me.control3dim rs as recordset
set rs = me.recordsetclone
for each " " in me.controls
if not isnull(c) then
with rs
.addnew
!field = x
!field = y
etc, etc...
.update
end with
end if
next c
