Combobox refresh

[Paul M]

Hy all

I have one ComboBox control, based on a query.
I have write for NotInList event:
strsql = "INSERT INTO articole ( artcod, artname, artactiv, arttip )
values ("
strsql = strsql & "'" & NewData & "','" & denart & "'," & "true, true);"
DoCmd.RunSQL strsql
....

My problem is that:
Records in ComboBox are not requeried, are not refreshed ...but the new
record are inserted in table.

How can i get this inserted record in combo ???

TIA
Paul

 

[Dan Artuso]

Hi,
Try re-querying the combo after the insert.
Me.yourCombo.Requery