onefootout
Technical User
Can someone tell me what "Call passthroughrecordset" is doing here? I've never seen this before, and I can't find any references or anything.
I'm trying to figure out how this button does what it does. Which the end result is that it places a new record in a table, based on the customerid of the current customer. I think.
Thanks!
K
Private Sub Command20_Click()
If Nzs(Me!CustomerId) Then Exit Sub
DoCmd.Hourglass True
Dim str1 As String
str1 = "InsertOrder " & Me!CustomerId
Dim rst As Recordset
Call passthroughrecordset(str1, "", 0, -1, rst)
Dim frm As Form
Set frm = Forms!PrefHide
frm!OrderID = rst!OrderID
rst.Close
Call OrderFormSource(frm)
DoCmd.Hourglass False
Forms!ORDER!MainFormControl.SetFocus
End Sub
I'm trying to figure out how this button does what it does. Which the end result is that it places a new record in a table, based on the customerid of the current customer. I think.
Thanks!
K
Private Sub Command20_Click()
If Nzs(Me!CustomerId) Then Exit Sub
DoCmd.Hourglass True
Dim str1 As String
str1 = "InsertOrder " & Me!CustomerId
Dim rst As Recordset
Call passthroughrecordset(str1, "", 0, -1, rst)
Dim frm As Form
Set frm = Forms!PrefHide
frm!OrderID = rst!OrderID
rst.Close
Call OrderFormSource(frm)
DoCmd.Hourglass False
Forms!ORDER!MainFormControl.SetFocus
End Sub