Dear Bianca,

Since I d/l data from SQL server, I have 2 combobox, one for selecting the time period, the second one is to select the status...I used

cSQL = "Select * from inventory where status = ?lcStatus and orderdate > ?lcDate"
SQLEXEC(cSQL,gnconnect,table1)

In this way, the data can be refresh.

Concerning the combobox selection... I got a table

LOG_STATUS
cStatus lcStatus cLevel
Delete 0 9
Ordering 1 1
Procuring 2 2
Approving 3 3
Delivering 4 2

whereas 1=Every User; 2=Procurement Officer; 3=Procurement Manager; 9=Administrator

In case you just want to show those orders enabled by Procurement Officer
"Select * from log_status where cLevel <= 2 into cursor tmp_status order by lcStatus"

TMP_STATUS...
Ordering 1 1
Procuring 2 2
Delivering 4 2

So Setting the rowsource to 2 "Alias", by selecting different cStatus, I have different lcStatus for displaying orders, since every user should belong to some groups, more complex can be using logic of 1,2,4,8,16,32,64 e.g.
cLevel=3 means it has the power of level 1 and level 2;
cLevel=7 means level 1, level 2, level 4


Hope this work for you