search by SSN

[Stingfish]

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

 

[pbaldy]

If it's a number:

DoCmd.OpenForm "FormName", , , "SSNField = " & Me.FieldName

if it's text:

DoCmd.OpenForm "FormName", , , "SSNField = '" & Me.FieldName & "'"

 

[Stingfish]

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.

 

[Stingfish]

I dont suppose you know how to make a button visible after the 12 digits have been typed in.

Im using this imput mask and as the last digit is clicked I want the
command button to be visible. I have set the command button to invisible on open on the forms properties
000\-000\-000\-000;;_

I done this before but it was on another DB and I cant remember which one it was. I will need a little prompting.

 

[pbaldy]

If you want it visible the instant the 12th digit is keyed in, this will work (presumes the button is not visible to start with):

Private Sub TextBoxName_Change()
  If Len(Me.TextBoxName.text) = 12 Then
    Me.CommandButtonName.Visible = True
  End If
End Sub

 

[Stingfish]

I Knew it was len but I could remember .

Thanks!