What is the data source of the form? You mentioned multiple tables - are the tables all included in the data source of the form? What is the source of the combo box and how does it relate to the...

There's more than one way to skin a cat but I might attack it like this (if I understand what you are trying to do correctly):

Open the text file in Excel - parse out the field to another column...

Why would it create a duplicate record if you are changing the person in that position? You would be editing the record rather than creating a new one. What is it about your table structure that...

Is it possible you are over complicating this? If you are trying to append to the form's data source you just set the value of each control and when you move off the form, it will be save to the...