>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.
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)
