Dim strSQL As String 'Set row source for list box strSQL = "SELECT Company.DUNS_Number, Company_Company_Name, " strSQL = strSQL & "WHERE Company_Company_Name like '" & [Forms]![CompanyMain]![Text69] & "*'" 'Update List Box with search results Me!List16.RowSource = strSQL DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 Me.List45 = Null Me.List53 = Null End Sub
|Send a .ZPL file to a network printer from Access||8||53|
|The object invoked has disconnected from its clients. AND Method 'OpenDatabase' of object '_DBEngine' failed errors||7||36|
|Transfer records between two Access tables||6||38|
|How to format a date field in an expression within a query in Access 2010||5||35|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!