what i have is a form button event that dims the vars and opens another form, passes the openArgs and performs a search.
The problem I'm having is the search is case sensitive so unless the case is correct i get no results. I have spent a bit of time on it and just can't work it out.. this is what i have..
Dim strpartnumber As String
strpartnumber = Me.[PartNumber]
DoCmd.OpenForm "SOS_SEARCH_F2", acNormal, , , acFormEdit, _
Dim strpartnum As String
strpartnum = Forms!SOS_SEARCH_F2.OpenArgs
If Len(strpartnum) > 0 Then
DoCmd.FindRecord strpartnum, , True, , True, , True
So if i search for 1abc and the PartNumber 1ABC i get no results.
Thanks in advance for any help.