combo box selected item

[cheaster]

hi

i have two question
first:
i want to use a macro in Visual basic 6, which macro select each item of my combobox step to step, my problem I cant set the selected item in combo box?

two:
how can i get the rows from my table from first to last and put to variable?

thanks cheaster

 

[namliam]

1) Why would you want to do that?
You can just set the value, not set the "selected" but set the value.

2) How do you mean?? Like a recordset??
Dim rs as DAO.Recordset ' **
Set rs = Currentdb.Openrecordset("Select * from Yourtable")

Now RS contains your table.
** If you get an error on this line, search the forum for the error. Its a common one.

 

[cheaster]

I would like to do this because i want to select each value and then use this value in a query and after select the next value and use an another query. and i want to use a macro which select automatical the values and call the query for this value.

 

[namliam]

Why use the combobox though? Why not put a parameter to your query?

Anyway the tools to do it are in my previous post, let me know if you still have troubles.