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?
