Combobox

  • Thread starter Thread starter hermie
  • Start date Start date
H

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
 
Where to put this statement?

herman

Barron Henderson said:
use me!ComboBoxName.refresh after you add the item.


hermie said:
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
Click to expand...
Click to expand...
 
Back
Top