Continuous Form GoTo specific record

[eighthman11]

Using Access 2000. I have a continuous form which for simplicity sack
has two fields Social Security Number and Last Name.

In the header of the continuous form I have a textbox where you can
type in any part of a social security number and when you do I want it
to take the user to the closest match SSN record in the continuous
form.

For Example you have three records
SSN LastName
111-11-11111 Jones
222-22-22222 Smith
333-33-33333 Tyler

Is the user types in a 2 in the textbox and clicks the find button;
the first record in the continuous form will be SSN 222-22-22222 and
you would still have the ability to scroll up
or down to see the records above and below.

Right now I am using a Filter. For example when the user types in a
2, I do a filter saying give me all SSNs which are >= 2. This works
ok but the user can not scoll up.
Any help would be appreciated.

[salad]

eighthman11 wrote:

Using Access 2000. I have a continuous form which for simplicity sack
has two fields Social Security Number and Last Name.

In the header of the continuous form I have a textbox where you can
type in any part of a social security number and when you do I want it
to take the user to the closest match SSN record in the continuous
form.

For Example you have three records
SSN LastName
111-11-11111 Jones
222-22-22222 Smith
333-33-33333 Tyler

Is the user types in a 2 in the textbox and clicks the find button;
the first record in the continuous form will be SSN 222-22-22222 and
you would still have the ability to scroll up
or down to see the records above and below.

Right now I am using a Filter. For example when the user types in a
2, I do a filter saying give me all SSNs which are >= 2. This works
ok but the user can not scoll up.
Any help would be appreciated.

In the AfterUpdate event you could enter some code like
Dim rst As DAO.Recordset
set rst = Me.RecordsetClone
rst.FindFirst "SSN = '" & Me.TextBoxName & "'"
If not rst.NoMatch Then Me.BookMark = rst.BookMark
rst.close
set rst = Nothing

I have no idea what your textbox name is.

[storrboy]

Look into using the RecordsetClone and bookmark properties as well as
the Find methods (assuming DAO). The wizard used when creating form
controls will generate code that's fairly easy to modify to suit your
needs.

[eighthman11]

On Mar 21, 11:18 am, "storrboy" <[e-mail]:

Look into using the RecordsetClone and bookmark properties as well as
the Find methods (assuming DAO). The wizard used when creating form
controls will generate code that's fairly easy to modify to suit your
needs.

I would like to thank everyone for their help. The FindRecord worked
great. All I had to do was add a wildcard "*" to the end of the
search criteria that the user types in the text box. This brings me
to the closest match record in the continuous form.
Thanks again.