Combobox

[hermie]

On my form in have a combobox that looks in a table of universities and
schools. When I want to add an item that is not in the list, I add the item
to table Universities. But after adding the item I cannot choose it in my
open report. I first have to close the report to select the new name of the
university. The row source of the combobox is: SELECT DISTINCT
universidades.IDuni, [NOMBRE_INSTITUCION] & ", " & [ADDRES_CITY] AS
Institución FROM universidades ORDER BY [NOMBRE_INSTITUCION] & ", " &
[ADDRES_CITY];

Is there a way to not close the report to select the new added item?

Herman

 

[hermie]

Where to put this statement?

herman

use me!ComboBoxName.refresh after you add the item.

On my form in have a combobox that looks in a table of universities and
schools. When I want to add an item that is not in the list, I add the item
to table Universities. But after adding the item I cannot choose it in my
open report. I first have to close the report to select the new name of the
university. The row source of the combobox is: SELECT DISTINCT
universidades.IDuni, [NOMBRE_INSTITUCION] & ", " & [ADDRES_CITY] AS
Institución FROM universidades ORDER BY [NOMBRE_INSTITUCION] & ", " &
[ADDRES_CITY];

Is there a way to not close the report to select the new added item?

Herman