Search results

Hey, I'm trying to add a search bar to a form which is linked to multiple tables. I've got it so that it will go to some records but not all of them when you select them. Anyone have any ideas? Code: Private Sub Combo89_AfterUpdate() 'Moves to Customer Name text box and 'finds the...

Hey, I'm trying to create a code which selects some records from one table and posts them into another. I'm a complete beginner at this but I've managed to get this far: Private Sub Command83_Click() Dim strSQL As String Dim strCriteria As String strSQL = "" strSQL = strSQL & " INSERT INTO...