Help! Records being overwritten

[SMatthews]

I have a table with a Customer Name and a Customer ID column. There can be many Customer IDs for one Customer Name. I have a form that displays the Customer Names in a combo box (using an SQL statement to Group) and has a subform that displays the Customer IDs in datasheet view. I want users to be able to select a Customer Name and then update the Customer IDs. When they need to add a Customer, I have them click a command button which runs a macro that closes the current form, goes to a new record in the table and opens a new form (with a text box that they can enter the Customer Name in). After they enter the new Customer Name and click "DONE", the current form closes and the other form opens back up. The new Customer Name then appears in the combo box. Everything works fine except that whatever Customer Name was selected in the combo box when the user hits the command button to add a new record overwrites the Customer Name of the very first record in the table. I'm sure there is a better way to do what I am trying to do, so any help is much appreciated!

 

[bat17]

It sounds like you have the control sorce for the combo box bound to the form which would cause you that problem.

removing the control source should cure it.

Peter

 

[SMatthews]

That was it! Thank you for your help!