error in create search form with combobox

[navid136220]

hi
i am beginner in access, i get 3 part learning video with title " Access- How to Create Search Form Using Combo box Part 1" (and part2,3) and i see its contents, but when i make tables, queries, subforms and forms like it, dosnt work correctly and i dont know why is this. if someone can find its sample file or create example file for it and upload file, so much thanks.


with regards: navid

[ranman256]

Make a continuous form of records.
put the combo box on it, when user pick the item in the combo, filter the records.

sub cboBox_afterupdate()
If isNull(cboBox) then 
  Me.filterOn=false
else
   Me.filter="[field]='" & cboBox & "'"
   Me.filterOn=true 
end if

end sub