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.

Well, if your not on a network, then performance should not be an issue if
you use the wizard.

So, in the top part of your continues form (the form heading part), simply
drop in a combo box

Make sure the wizard wand button is selected. From that point on, ms-access
will create the code and a box that allow you to select a part number....

So, try the wizard, it will create a drop down, and if you can simply type
in the part number, or select it from a list....



--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)

Many thanks Albert!

Regards,

Franc.

"Albert D. Kallal" wrote:

> Well, if your not on a network, then performance should not be an issue if
> you use the wizard.
>
> So, in the top part of your continues form (the form heading part), simply
> drop in a combo box
>
> Make sure the wizard wand button is selected. From that point on, ms-access
> will create the code and a box that allow you to select a part number....
>
> So, try the wizard, it will create a drop down, and if you can simply type
> in the part number, or select it from a list....
>
>
>
> --
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> (E-Mail Removed)
>
>
>