Penrodcigar
Technical User
Using the .Move numrecords, start: method Access gives me the error message “Sub or Function not Defined”. The actual lines of code read:
Dim PrIDVar As String
PrIDVar = Me.Face.Value ‘where the value is the
row selected with a combo box
that has the bound column set
to “0” ie 7 for the 8th row of
the table selected in the
combo box)
Dim myConnection As ADODB.Connection
Set myConnection = CurrentProject.Connection
Dim myRecordset As New ADODB.Recordset
myRecordset.ActiveConnection = myConnection
myRecordset.Open "SELECT Products.Face, Products.[Product
Supplier], ....sql statement etc...FROM
Products ORDER BY Products.Face"
myRecordset.Move numrecords("PrIDVar") ‘to move the curser
to the intended
row of the table
Here is where the compiler gives me the error message. What have I missed here?
Dim PrIDVar As String
PrIDVar = Me.Face.Value ‘where the value is the
row selected with a combo box
that has the bound column set
to “0” ie 7 for the 8th row of
the table selected in the
combo box)
Dim myConnection As ADODB.Connection
Set myConnection = CurrentProject.Connection
Dim myRecordset As New ADODB.Recordset
myRecordset.ActiveConnection = myConnection
myRecordset.Open "SELECT Products.Face, Products.[Product
Supplier], ....sql statement etc...FROM
Products ORDER BY Products.Face"
myRecordset.Move numrecords("PrIDVar") ‘to move the curser
to the intended
row of the table
Here is where the compiler gives me the error message. What have I missed here?