Search results

I just found the solution. I put this in for the After Update event of the combo-box: Me.cboParentSid.Value = Me.cboParentSid.Column(1)

I have a combo box for Parent_Sid that shows the Parent_Sid for a specific customer and also allows users to make changes using the drop-down list. When the user clicks on the down arrow, it show Customer_Name (Primary Key) and in the next column Customer_Sid. The user will look for the...

I really appreciate your time and effort! They work perfectly! That is a good point. Thank you for your suggestion.

Those perfectly works! Thanks a lot. I realized there are some case sensitivity issues so I had some minor changes. So right now they are like: strSearch = LCase(Me.txtSearch) DoCmd.OpenForm "frmParentMapEntry", acNormal, , LCase("[CUSTOMER_NAME] Like '") & Replace(strSearch, "'", "''") & "*'"

Is strSearch = Me.txtSearch Also works?

If users search customer information using CUSTOMER NAME then the filter apply to CUSTOMER_NAME in the frmParentMapEntry form. If they search using CUSTOMER NUMBER then the filter apply to CUSOMTER_NUMBER.

If I want to use like for CUSTOMER_NAME, is this correct: DoCmd.OpenForm "frmParentMapEntry", acNormal, , "strSearch like '" & [ CUSTOMER_NAME] & "'" Since I define strSearch as a string, do I need to turn CUSTOMER_NUMBER and CUSTOMER_SID as string too? Like STR$[CUSTOMER_NUMBER]

I'm trying to find the best way to do the following: 1. the user select desired search option from the option group (opgSearchOption) - see 1st attachment 2. Validate at least one characteristic has been entered in Search Box (txtSearch) 3. when the user click Search button, open the form...

Hello! I'm Evelyn and I'm new to the forum. I have years of experience of Excel and SQL but I'm fairly new to Access and VBA. Thanks for let me join.