How Do I: Make Command Button Use Entry From Text Box.

[RichardAnderson]

Hello Everyone..



I do not know code at all really but what I want to do would probably be very simple.

I have a form with hundreds of records and growing. I was asked if I could add a header to the top of the form with a textbox and a button. WHat needs to happen is a user would type in the number of the record they want to goto and when they click the button they would go straight to that record. Kind of like the Find record button but without the extra window.

EDIT: I will mark this solved. I found I need to do this differently now.

[TG_W]

Try the code below. You could set this as your 'After Update' event on the text box where you enter the record number, or make it your button command 'On Click'

    Me.FilterOn = False
    Me.Filter = "[RecordFieldNameHere] Like '*' &[Forms]![YourFormNameHere]![RecordNumberTextBox] & '*'"
    Me.FilterOn = True
    Me.Requery

EDIT:

If you do not want the wild cards on either side, simply delete the '*' and & from either side of the form call