Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.
Private Sub LoadAvailableTechs() DoCmd.SetWarnings False Dim pSQL As String pSQL = "SELECT * FROM Staging_Table ORDER BY Staging_Table.Tech_Name" Me.dataAvailabilitySubform.SourceObject = "Query.qryStagingTable" Me.dataAvailabilitySubform.Form.RecordSource = pSQL Me.dataAvailabilitySubform.Requery Me.dataAvailabilitySubform.Form.AllowEdits = True Me.dataAvailabilitySubform.Form.AllowAdditions = False Me.dataAvailabilitySubform.Form.AllowDeletions = False DoCmd.SetWarnings True End Sub
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.