Change to selection in combo box

[corystemp]

I create a combo box that after every entry it adds the new part number to that box. the problem i am having is that altough it adds the part numbers correctly as i add them when i make the selection in the combo box it doesnt change to that part. How can i make it so when i pick a part int he combo box the record on the screen changes to that one?

[RuralGuy]

Use the ComboBox wizard and select #3 and you will see how to achieve what you want. Then incorporate the code in your current cbo and delete the wizard created one.

[corystemp]

That worked. now the problem i am having is that when i click on my button to add a new record, it works fine and i get a clear form, i add the info and it saves just fine. the problem is after i enter that info. It doesnt show up in the combo box till i close the form and reopen it. not even if i save it. how do i get it do instantly appear in the combo box or after i click save so i dont have to close the form everytime.

[RuralGuy]

Since the control in now not bound you need to create a procedure that places the field you want in the window of the control. Then call that procedure from the OnCurrent event of the form.

[corystemp]

sorry but how do i do that?

[RuralGuy]

With the form in design mode on the event tab of the properties sheet, go to the OnCurrent Event row and press the "..." button which should take you to the code module. Does it?

[corystemp]

that gets me to the code module, but what do i select in this spot?

[RuralGuy]

Me.ComboBoxName = [YourFieldName]
...should do it; using your names of course.