Search results

Hi All. I create two forms: 1. Main form to display records in ListBox 2. Detail form to add new record How to modify the Main form to give user ability to select and update record? If it is possible. Thanks.

The correct syntax for strSql: strSql = "Select * from qRequestFilter WHERE Request Like ""*" & Me.txtRequest & "*""" or strSql = "Select * from qRequestFilter WHERE Request Like '*" & Me.txtRequest & "*'"

Hi MajP. I tried to modify your code for string value in AfterUpdate event Private Sub txtFilter_AfterUpdate() Dim strSql As String strSql = "Select Request from qRequestFilter " strSql = strSql & " WHERE Request = " Like '" & Me.txtFilter & " * '" strSql = strSql & " ORDER...

Hi Pat. Thanks for reply. Sorry. You should be miss understood. Previously I binded forms to tables or queries by using properties rowsource. Now I would to create with advance way by using recordset and ask a help to figure out how it to do. Thanks

Hi theDBguy. Thanks for reply. I never populate form or controls using recordset but I would like to do it. I will appreciate if you will share sample file with brief explanation. Thanks

Hi All. In my form I'm populating ListBox thru RowSource. How to populate ListBox with Recordset? If it is possible. And what need to use ADO or DAO? I will appreciate for sample and detail explanation. Thanks.

Hi All. I'm trying to create VBA code to filter ListBox via value of TextBox. On online I found sample that is very similar to what I need Private Sub txtDate_Exit(Cancel As Integer) Dim sFilter As String, oRS As DAO.Recordset If IsNull(txtDate) Then DoCmd.ShowAllRecords: Exit Sub...