Making changes in a form that updates a table

[woundup]

In the attached DB I have a form that has a combo box which enables you to select an employee and all the employee info is then pulled based on the selection. I want to make changes to the info in the form and have the changes update the correct employee on the table. Currently the from will not let me make changes to the info and the table seems to add new lines rather than updating the corresponding line. Any suggestions?

Thank you in advance!

[rzw0wr]

Can't download your Database.

Dale

[woundup]

Employee Contact.zipDale,

Let's see if this file will work. If not can you view using Access 2007-2010?

[rzw0wr]

woundup, you can not change any text box because it is bound to the combo box 254.
You are not populating the form from the table, you are populating the from from the combo box.

I have 2010, the first upload gives an error.

Dale

[woundup]

Is there any other way to use a combo box to populate the info for the employee selected w/o binding the text boxes to the combo box?

[rzw0wr]

You form has underlying data from the table.
When you make a combo box for the form use the 3rd option.
Then add all of the fields you need to the form.
Leave the text boxes bound to the fields.

The form will populate whenever you select something in the combo box.

Dale

[rzw0wr]

Look at Form1 in this database.
I changed your Employee Number to Number type.

Test.zip

Dale

[woundup]

I must be doing something wrong. I have changed each text box so they are no longer bound to the combo box. I also deleted the combo box and then added it back in using option 3 on the wizard, but when I select an employee the remaining data does not populate.

[woundup]

Sorry posted to fast. I got it to work.

Thank you so much!