Search results

You must use the Bookmark property. Private Sub Cycle_Records_Click() Dim stdocname As String Dim Rst As Recordset Set Rst = Me.RecordsetClone Do Until Rst.EOF Rst.MoveNext ' Next in Rst If Not Rst.EOF then Me.Bookmark = rst.Bookmark ' Next in Form End If Loop End Sub

I have a form with Recordsource based on a stored procedure in an MSDE SQL server. I pass an Openargs value to the form from a seek-form, to find a specific record in the On open event. BUT! The On open event does not wait until the form / recordset is populated, and so I can't find more than...

I have a form with Recordsource based on a stored procedure in an MSDE SQL server. I pass an Openargs value to the form from a seek-form, to find a specific record in the On open event. BUT! The On open event does not wait until the form is populated, and so I can't find more than the first 50...

I have a form with Recordsource based on a stored procedure in an MSDE SQL server. I pass an Openargs value to the form from a seek-form, to find a specific record in the On open event. BUT! The On open event does not wait until the form is populated, and so I can't find more than the first 50...

Try using a stored procedure in MSSQL which returns a single value based on an SQL query