recordcount for textfield is it possible

[indhu]

hi

table:shot

dim storyboard as ADODB.recordset

recordcount shld populate in textbox.

panel: A, B C,D(am using combobox)
Noofpanel=4txtb ox or label is this possible.

i tried using scene_txt(combo box name)
but didn't work anything.

Private Sub scene_txt_change()
Label12.Caption = "shot" & panel_txt.Recordset.AbsolutePosition + 1 & _
"of" & panel.Recordset.RecordCount
End Sub

am going in a wrong direction,direc t me pls

[hariharanmca]

hi

table:shot

dim storyboard as ADODB.recordset

recordcount shld populate in textbox.

panel: A, B C,D(am using combobox)
Noofpanel=4txtb ox or label is this possible.

i tried using scene_txt(combo box name)
but didn't work anything.

Private Sub scene_txt_change()
Label12.Caption = "shot" & panel_txt.Recordset.AbsolutePosition + 1 & _
"of" & panel.Recordset.RecordCount
End Sub

am going in a wrong direction,direc t me pls

which connection you are using?

[indhu]

which connection you are using?

Public Sub myconnection()

Set CON = New ADODB.Connection

    CON.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\storyboard.mdb;Persist Security Info=False"
End Sub

[hariharanmca]

hi

table:shot

dim storyboard as ADODB.recordset

recordcount shld populate in textbox.

panel: A, B C,D(am using combobox)
Noofpanel=4txtb ox or label is this possible.

i tried using scene_txt(combo box name)
but didn't work anything.

Private Sub scene_txt_change()
Label12.Caption = "shot" & panel_txt.Recordset.AbsolutePosition + 1 & _
"of" & panel.Recordset.RecordCount
End Sub

am going in a wrong direction,direc t me pls

yes, You are going in wrong way,

Label12.Caption = "shot" & panel_txt.Recor dset.AbsolutePo sition + 1 & _
"of" & panel.Recordset .RecordCount

in this code

panel_txt.Recor dset
panel.Recordset
may not be same value