using 'find a record' in a combo box on a form?

[Kim]

I have a combo box of categories on a form- the user can scroll through the
combo box to find the selection they want to set.
However the list is long and I want to be able to find the value of a
category instead of having the user scroll.

I tried putting a 'find record' command on the form - but this does not work
on the combo box and will work on any of the text fields.

the combox box is based on a query of ONLY the category names - no other
fields.

What am I doing wrong?

Thanks in Advance

 

[grep]

Kim,

If I'm understanding you correctly, you're trying to find a unique User
record by specifying a Category. If so, it doesn't work because you're
not identifying a specific record.

If so, there are a number of ways you could try to go about it. How
about two combo boxes? One for categories, and one for users. You could
then run a query in the User box to limit its list to those who are also
members of the category you selected in the first box.

As Allen Browne suggested to me, see
http://www.mvps.org/access/forms/frm0028.htm

grep

 

[Kim]

Actually it is less complicated than that.
And I starting to think I cannot do what I want to do...

here is a portion of the list


ag-tires
air-conditioning-coolant-exchanging-tools
air-conditioning-dye-injecting-tools
air-conditioning-flushing-machines
air-conditioning-installation-tools
air-conditioning-leak-detecting-tools
air-conditioning-manifolds
air-conditioning-removal-tools
antenna-toppers


Let's say I wanted to select the category 'antenna-toppers' - but it was
midway through a very big list. I am not really sure what the complete
category is but I know that it contains the word 'topper' - I want to be
able to type in topper and have the list take me to that value.

What is the easiest way to do that?

THank you,
Kim

 

[grep]

I see. It seems to me that the best way to do it would be to restructure
the data, but barring that, I suppose you could use the Find function,
instead of the Combo box. Using Find, you can search for text within a
field, etc. It's just not quite as convenient.

I'm sure there are others here who will know better ways to handle the
problem. I'd wait for them first.

grep

 

[Kim]

Hi Grep,
what I did was add a text field on the form as well as a new button for
'search list' -
enter a value into the text box click on the button and the list is
filtered.
Does exactly what I needed it to do,
Now there may be another way to do it.. but this works for me.

Thank you for your help,
Kim

 

[grep]

If it works, it's all good.

grep

Hi Grep,
what I did was add a text field on the form as well as a new button for
'search list' -
enter a value into the text box click on the button and the list is
filtered.
Does exactly what I needed it to do,
Now there may be another way to do it.. but this works for me.

Thank you for your help,
Kim