Search results

I am trying to insert data from a form to antother table in VBA and would like to do this without using a macro. I have got the following code but it doesn't work. Can anyone help me???? Dim appointmentdate As String Dim db As DAO.Database Dim rst As DAO.Recordset Dim strsql As String Set...

Hi I am trying to put a simple search facility on my database without using a combo box/filter. I have got this far below, but this will only find 1 record and then won't search any futher. Can anyone help me please?? Thanks Louise Private Sub Command156_Click() Dim strnhsRef As...