Hello,
I have a combo box w/ 6 search criteria (EmpID, EmpName, ect..) i tried building the onclick() resopnse in the macro builder but i could not fit all the criteria into the line. i dont even know where to start and all the searchign i have done has just been people showing how to open and close windows.. not look up data entered into a text field... If i could get some help w/ getting started i think i would be alright.. this is what i got for the code for the macro builder and it works i just cant fit all the criteria in due to text length limits:
[Emp_ID] Like "*" & [Forms]![frm_WIGI_Search]![txt_Search_Box] & "*" Or [Emp_Name] Like "*" & [Forms]![frm_WIGI_Search]![txt_Search_Box] & "*" Or [WGI_Due_Dt] Like "*" & [Forms]![frm_WIGI_Search]![txt_Search_Box] & "*"
but i need the rest of this added to that:
[Date_LEI] Like "*" & [Forms]![frm_WIGI_Search]![txt_Search_Box] & "*" Or [AO_Code] Like "*" & [Forms]![frm_WIGI_Search]![txt_Search_Box] & "*" Or [WIGI_Approval_Status] Like "*" & [Forms]![frm_WIGI_Search]![txt_Search_Box] & "*"
I tried looking at the SQL from a qurey i designed but it didnt help much..