code_junkie

Creating Recordset in VBA wit SQL statement

Nov 11th, 2011
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. Private Sub Form_Load()
  2.  
  3. Dim rst As Recordset
  4.  
  5. Set rst = CurrentDb.OpenRecordset("Select [ID], [Ln] From [Order Detail] Where ((([Order Detail].[ID]) = [Forms]![Order Data Entry Header]![ID]))")
  6.  
  7. rst.MoveLast
  8. Forms![Order Data Entry Header].LineNum = rst![Ln]
  9.  
  10. End Sub
  11.  
  12. Set rst = CurrentDb.OpenRecordset("Select [ID], [Ln] From [Order Detail] Where ((([Order Detail].[ID]) = " & [Forms]![Order Data Entry Header]![ID] & "))")
Add Comment
Please, Sign In to add comment