results returned to appear in a combo box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maax - 06 Mar 2007 14:33 GMT

Hi All, i have a partnumber search that returns several "like" part numbers.
if i enter "1533" it returns all parts starting with this. This is the
desired result.
However The result is being returned in a form, with the first occurence
showing in the partnumber field. Again this is how i want it.
However if there are sevferal parts matching i would like to be able to use
the partnumber field as a combo box with the results available to pick from.
Currently if there are 13 results I have to use the record navigation
buttons at the foot of the form to go to the desired record.

How do i get the results available in the partnumber field using a combo box.

many thanks

Reply to this Message

Al Campagna - 06 Mar 2007 14:47 GMT

Maax,
Not sure if I understand... I'm assuming you want to find a particular PartNo record,
by "partial" PartNo", and then operate on that record. There should be a simpler
solution.
I have a sample file on my website below called Quick Find Combo (A97 or A2003) that
allows you to jump right to the PartNo record you want.
A combo box with AutoExpand set to Yes will attempt to find the correct selection "as
you type", so it would work just like your current parameter method.
If you type 1533, only those PartNos with 1533 will be displayed in the combo for
selection. Select one of those, and jump right to the record.

Signature

hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

> Hi All, i have a partnumber search that returns several "like" part numbers.
> if i enter "1533" it returns all parts starting with this. This is the
[quoted text clipped - 9 lines]
>
> many thanks

Reply to this Message

Maax - 06 Mar 2007 15:41 GMT

erm i am a little confused. (i am very novice).

currently when i run the form "partnumbersearch" i am presented with a
"enter parameter value box"
I enter the full or partial number which opens the form.
The form has a field "partnumber" This is already set to an auto expand
combo box but only lists the very first record.
If i iwant to view the other matching records i have to use the record
navigation buttons which work ok but is not ideal.

As i click through the records the fields on the form are updated
accordingly, displaying the correct details.

once i have navigated to the record i require i then click on a button that
i have on the form which opens the currently displayed record (using the
unique LOGID field) in a new form that i use to edit the record.

This works but i would really like to hide the record navigation buttons and
have the records show in the combo box.

I have looked at your example and i am not sure if that is what i need. I
have tried to make it work without success.

> Maax,
> Not sure if I understand... I'm assuming you want to find a particular PartNo record,
[quoted text clipped - 19 lines]
> >
> > many thanks

Reply to this Message