Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.
Private Sub List78_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "Call_Ticket" stWhoCalled = "DirectAccess" stLinkCriteria = "Forms!Call_Ticket!Service_Tag_No = " & Me!List78 DoCmd.OpenForm stDocName, , , stLinkCriteria End Sub
If stWhoCalled = "DirectAccess" Then Me.RecordSource = "OpenQuotes" Me.Caption = "You are Editing Open Quotes" End If
SELECT DISTINCTROW Main.CompanyName, Main.Real_Name, Main.Billable, Main.Distance, Main.Phone_Number, Main.Problem, Main.Call_Open_Time, Main.[Call_Close Time], Main.Installation_Date, Main.Service_Tag_Number_Auto, Main.Type_Support, Main.Address_1, Main.Address_2, Main.City, Main.State, Main.Zip_Code, Main.QBInvoiceNumber, Main.Billed, Main.Keep4Today, Main.Parts, Main.[Project Name], Main.Total, Main.EstHours FROM Main WHERE (((Main.[Call_Close Time]) Is Null) AND ((Main.Type_Support)="Proposal / Quote")) ORDER BY Main.CompanyName;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.