Code,please go through

[Vbbeginner07]

[code=vb]
Private Sub ListView2_ItemC lick(ByVal Item As MSComctlLib.Lis tItem)
If ListView2.Selec tedItem.Checked = True Then
rs.Open "select * from saldetail where date = '" & ListView2.Selec tedItem & "'", conn, adOpenStatic, adLockOptimisti c
If Not rs.EOF Then
rs.MoveFirst
Do While Not rs.EOF
res1 = 0
If Trim(txttr.Text ) = "" Then
Form3.txttamt.T ext = ""
MsgBox "enter the tax rate", vbOKOnly, "ERROR"
cbostate.SetFoc us
Else
res1 = txttr.Text / 100
' rs.MoveNext
End If
txtoh.Text = Val(txthrs.Text - txthrs.Text)
txtotamt.Text = Val(txtoh.Text * txtotrt.Text)
res = Val(txthrs.Text * txtrate.Text)
Form3.txttamt.T ext = Val(res * res1)
Form3.txtgros.T ext = Val(txthrs.Text * txtrate.Text)
'str1 = txttr.Text
Form3.txtnsal.T ext = Val(Form3.txtgr os.Text - Form3.txttamt)
rs.Close
Set rs = Nothing
[/code]

If we click one record in the listview it should show the corresponding record from datbase.....

oneid--------------------several working days
so for each working day one record from the datbase........ ..
please go through....Than ks in advance
NICK

[debasisdas]

so, what is the problem ?

[Vbbeginner07]

so, what is the problem ?

the control doesnot move out to each record in database,ie not displaying the record.

[QVeen72]

the control doesnot move out to each record in database,ie not displaying the record.

Your Do While does not have a "Loop"
I guess, your code does not even compile..
Properly Indent the Code, it will help you a lot to write Strurtured syntax..
[code=vb]
Do While Not RS.EOF
'Your code to populate text box here
RS.MoveNext
Loop
[/code]

Regards
Veena

[debasisdas]

the control doesnot move out to each record in database,ie not displaying the record.

but,you are not retriving anything from recordset .

[Killer42]

Your Do While does not have a "Loop"
I guess, your code does not even compile..

Given that the code has obviously been compiled, it's evident that not all of it is posted here.

Perhaps it would help if the entire Sub were posted, at least.