Mikel
Posts: 7
|
| Posted: 07/18/2007, 6:43 PM |
|
Hi
Maybe some of you guys have an answer for this problem.
I have a table with contact information and they have a category field with Friend and Enemy. how can I just show all friends in a Listbox on antother page
thanks again
Mikel
|
 |
 |
ckroon
Posts: 869
|
| Posted: 07/19/2007, 5:14 AM |
|
Hi Mikel.
It's pretty easy.
Click on the listbox itself. In the properties window on the right, under the data tab, click on the ... that is to the right of the data source.
A Visual Query Builder will pop up and in the Where statement there, put in your parameters. Click the Where button and then the plus sign. Slect the "enemy/friend" field form the list and then type in Friend or enemy, depending on which one you want to show, make sure you put it in single quotes: 'Friend'. And change it to an Expression.
That should do it.
_________________
Walter Kempees...you are dearly missed. |
|
|
|
|
