How to go to a specific record within continuous forms

[Guest]

Hello everyone,

I have a large table of parts, around 50,000 records. There is a separate
autonumber id and part number. The continuous forms form which is used to
view the data sorts on part number and not autonumber id. I want to make a
quick pop-up tool which will act like Find (CTRL + F), but which will give a
drop-down of the part numbers as they are long and complicated and it is easy
to mis-type them.

I have tried using GoToRecord. It performs the action, but it moves
backwards or forwards from a certain position. I can use the GoToFirst
method in the previous line to give it a consistent point of reference, but I
can't find a way of identifying the position of a certain part within the
recordset.

I also tried FindRecord, but this didn't actually go to the specific record
within the set.

Where am I going wrong?

Thanks,

Franc.

 

[Baz]

With Forms!frmSomeForm
.RecordsetClone.FindFirst "part_number = """ & Me!cboPartNumber & """"
If .NoMatch Then
MsgBox "Part not found"
Else
.Bookmark = .RecordsetClone.Bookmark
End If
End With

 

[Guest]

Thanks for that Baz.

Regards,

Franc.

With Forms!frmSomeForm
.RecordsetClone.FindFirst "part_number = """ & Me!cboPartNumber & """"
If .NoMatch Then
MsgBox "Part not found"
Else
.Bookmark = .RecordsetClone.Bookmark
End If
End With