|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
need help in search record
hey all ..hope u all enjoyed the xmas holidays....
I wann some help here.. I wanna search a record. But i wanna wildcat search by three methods..ie.. search in name coloumn or search by ID or search by Payroll ID column(name/ Id/ Pay ID are three columns in the table for this form) For that i created a search field ---->Search combo box to select Name or ID----->Combo107 and a command button to search the field -->Command109 but i dont know how to modify the VBcode my code is as follows I know that i need to change the line starting with stLinkCriteria = "[=[Combo107]] Like " & "'*" & ... --------------------------------------------- Private Sub Command109_Click() On Error GoTo Err_Command109_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "x-Contract Finder" stLinkCriteria = "[=[Combo107]] Like " & "'*" & Me![search] & "*'" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Command109_Click: Exit Sub Err_Command109_Click: MsgBox Err.Description Resume Exit_Command109_Click End Sub |
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > need help in search record |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|