Add record variable?

[smh]

This is what I want to do, and logically, this would seem to work, but it doesn't. I want the first field name to be a variable.

rsd.AddNew

Name = ("rsd!" + strComboBox)

Name = strComboContents
rsd!contact = frmForm!cboContact.Text
rsd!Phone = frmForm!mskPhone
rsd!extension = frmForm!txtExtension
rsd!fax = frmForm!mskFax
rsd!Email = frmForm!txtEmail

rsd.Update

Any suggestions on how to do this?

[Parseman]

How about this?

Dim TempStr as string


Tempstr = strComboBox

rsd.fields(Tempstr) = strComboContents



I'm not sure why your trying to make the recordset
a variable...I'm guessing your trying to make the field
name a variable...

Hope this helps...

[smh]

I tried something similar to that, and it's actually looking for the variable name as the field. I just ended up using a case statement instead of using a variable.

Thanks anyway!