> hey guys,
>
> i created a combo box using the way of Mr. Anil Sharma in his reply:
>
> **************
> just create a table with Name,QueryFile bound your combobox with that table. by rowsourcetype =6 and rowsource= "table.name,queryfile" and in the lostfocus event u can just run your selected query file like that
>
> do (table.queryfile)
> **************
>
> using this way, i can run my queries or programs smoothly, but, now i need to make multiple combo boxes in my form, and i can't use this way, because i cannot use many table at the same time to get data from them. so my question is:
> is there a trick that allows me to take data from many table ? or can i create queries to show different data in the combo boxes but all from the same table ?
>
> hope i didn't confuse u guys :)
>
> your help is highly appreciated
just drop comboboxes on form and in your form's init event write this
select your_table
scan for
thisform.combo1.AddListItem( feildname,id_field)
endscan
select your_table
scan for
thisform.combo2.AddListItem( feildname,id_field)
endscan
and so on!
Anil
(Fox is the solution for almost everything!!)