>>hi hilmar for this help
>>then ==> how select a table that in this table is a field by these value and other values ( all are in one field)
>>example: my listbox have ten fields and i want select a table only this field finded in it and selected these for send this query to a report
>>tank you
>
>My previous example was assuming that you want to add the values through a program. But if you need to fill a ListBox (or ComboBox) from a table, there is a simpler way. For example, let's assume you want to show two fields from the table.
>
>Set RowSourceType = 6 (Fields), and RowSource = "MyTable.Field1, Field2". Also, you will probably want to set Style = 2 (Dropdown List). Otherwise, the user can type in any value, instead of selecting something from the table.
>
>HTH,
>
>Hilmar.
Another key property, of course, is the ControlSource. The RowSourceType and RowSource tell VFP "from where do you want to select the list which the user sees"; ControlSource tells VFP, "where do you want to store the result".
The ControlSource will usually be a field in another table, or a form property.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)