dens0ne
Posts: 8
|
| Posted: 10/13/2009, 10:59 AM |
|
well im trying to make a search engine with a listbox, but one of the fields that it must contain its a listbox wich has nothing in it.
for example i have a listbox from a field named GENRE, when i click it i want it to display many GENRES, like action, horror, comedy, etc. (talkin about movies of course), do i need an event to do that?
or theres a property already for this?
Thanks for the help
|
 |
 |
Rick
Posts: 52
|
| Posted: 10/13/2009, 6:42 PM |
|
If I understand what you are asking:
Set listbox source as table and set where criteria for that field not equal to the blank value of the field.
If there is a possibility of duplicates you may want to use SQL as the source for the field and create the proper sql to select the proper values and include 'Distinct' syntax to show only unique values.
Hope this helps.
Rick
|
|
|
|
dens0ne
Posts: 8
|
| Posted: 10/14/2009, 10:10 AM |
|
Quote Rick:
If I understand what you are asking:
Set listbox source as table and set where criteria for that field not equal to the blank value of the field.
If there is a possibility of duplicates you may want to use SQL as the source for the field and create the proper sql to select the proper values and include 'Distinct' syntax to show only unique values.
Hope this helps.
Rick
got it,, thanks rick
|
|
|
|
|
