Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Private Sub Form_Load()
- Dim rst As Recordset
- Set rst = CurrentDb.OpenRecordset("Select [ID], [Ln] From [Order Detail] Where ((([Order Detail].[ID]) = [Forms]![Order Data Entry Header]![ID]))")
- rst.MoveLast
- Forms![Order Data Entry Header].LineNum = rst![Ln]
- End Sub
- 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