Combo does not show new values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I've got a form, in the that form I have a combo box that is filled by
some data that exists in a table. I n that form I also have a button, and any
time I need a value in that combo I press the button and another form will
open, the previous form is not to be closed. In the form that just open I
insert the new value that does to the table that have that data that fill tha
combobox. Everything is fine, till the moment I close the new formand return
to the previous. In this form, that contains the combox, whem I expand the
combobox the new value is not listed.

I know that is a simple thing to do, I don't know. Can somebody help me?

Regards,
Marco
 
Hi Marco,

When you return to the 'previous' form, execute the 'Requery' method of the
combo, e.g.

DoCmd.OpenForm "frmNewComboValue", WindowMode:=acDialog
Me.cboMyCombo.Requery

HTH
Richard
 
Marco,
You have to reestablish the recordset on the combobox. Did you fill the
combobox by code or through the properties window>rowsource?

-Brandon
 
Back
Top