Replies

Okay, here’s all the code that is showing. I don’t know much about Visual Basic.

Sub LastName_AfterUpdate()
‘ Find the record that matches the control.
Me.RecordsetClone.FindFirst “[StudID] = ‘” & Me![LastName] & “‘”
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

Sub Combo33_AfterUpdate()
‘ Find the record that matches the control.
Me.RecordsetClone.FindFirst “[StudID] = ‘” & Me![Combo33] & “‘”
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

Private Sub Cmd_Print_Current_Rec_Click()
On Error GoTo Err_Cmd_Print_Current_Rec_Click

Dim strDocName As String
Dim strFilter As String

DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 ‘Save record

strDocName = “Invoice”
strFilter = “tbl_Invoices.InvID = Forms!frm_Student!InvID”

DoCmd.OpenReport strDocName, acViewNormal, , strFilter

Exit_Cmd_Print_Current_Rec_Click:
Exit Sub

Err_Cmd_Print_Current_Rec_Click:
MsgBox Err.Description
Resume Exit_Cmd_Print_Current_Rec_Click

End Sub

I don’t know what the other two SUBs are, though ’cause like I said, I don’t know much of anything about VBA. I hope you can help.

Jennifer

Okay, I tried it again, Rupert. I got it to print, but now it asks for a Parameter value. What is that? And it still prints all of my invoices. Aaaaarrrggghhh!!!

Thanks for the help again, Rupert. I put the code in, but now I can’t get it to print anything. What did I do wrong? Am I suppose to replace all of the code that is there with your code?

Well, I tried it…and it didn’t work. You see I’m trying to incorporate 3 tables. I would like a screen where I can enter an invoice by first selecting the student that the invoice is for. That is where I can’t get the combo box to work–when I select a student. I have an invoice table that I want to get the invoice number from and then a fee table where I get the fee details for the invoice.

Am I combining them incorrectly. I used a query that brought them all together. Or should I select from all 3 tables when I do the auto form?

Okay, I’ll give it a try on Tuesday when I get back to work. Thanks, Rupert. I’ll let you know what happens.

Jennifer

It just comes up with the box that says “How do you want the combo box to get its values?”. It lists only two choices, not three.

I’ve got the wizard pressed.