Hi

I have coded a program to save edit delete orders.. now it is linked to db "db.mdb"

while edit and delete order.. what i want to do is that it shows only those order which has been entered by the logged in user.. that is identified by user_id field stored in order_detials table and the user id when logged in is stored in variable "userid"

so while populating my orderID in a combobox.. i guess i have to use some query like

select * from order_info where user_id = userid ( variable)

I am using the following method to open a db

Private Sub Form_Load()

Set ws = DBEngine.Workspaces(0)
Set db = ws.OpenDatabase(App.Path & "\db.mdb")
Set rs = db.OpenRecordset("order_details", dbOpenTable)

Set rs1 = db.OpenRecordset("item_info", dbOpenTable)

Do Until rs.EOF
cmborderid.AddItem rs!order_id
rs.MoveNext
Loop

Do Until rs1.EOF
cmbitem.AddItem rs1!item_name
cmbitemid.AddItem rs1!item_id
rs1.MoveNext
Loop

End Sub


can u tell me how to make a rs which populates the cmborderid with only those which are of current user only..