Search results

Thanks for that. Im getting a blank form when I hit the button. Im not getting the record show up. What am i doing wrong I said to myself. tried adding acNormal, , "[ClientID] = " & Me.txtEntry and it worked fine. Thank for pointing me in the right direction.

I have a text box on a search form where a user can enter the SSN. The user clicks a button and I want it to open the another forms that has the record. can some help please

Thanks Paul. I'll have a play around with it. cheers.

Im having a litle difficulty with the last few lines in the code. maily the last Mgsbox and VbYesNo Private Sub PrpSSN_AfterUpdate() Dim strRecordOwner As String Dim vntWhoGotIt vntWhoGotIt = DLookup("[ClientID]", "tblreferrals", "[ClientSSN]='" & Me.PrpSSN & "'") If Not IsNull(vntWhoGotIt)...