hi

[Alienz]

in design view go to the combo box properties

control source: TipoRua
row source type: SELECT DISTINCT [TABLE NAME].TipoRua from [TABLE
NAME] where TipoRua is NOT NULL