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=4txtbox or label is this possible.

i tried using scene_txt(combobox 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,direct 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=4txtbox or label is this possible.

i tried using scene_txt(combobox 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,direct 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=4txtbox or label is this possible.

i tried using scene_txt(combobox 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,direct me pls

yes, You are going in wrong way,

Label12.Caption = "shot" & panel_txt.Recordset.AbsolutePosition + 1 & _
"of" & panel.Recordset.RecordCount

in this code

panel_txt.Recordset
panel.Recordset
may not be same value