data lookup from a form entry

[Steve]

Hi...I am looking for a way to do the following:
When entering a part number into a form, I want the program to "look" at the
part number, and determine if that part number is in a list of part numbers
on a table, and if it is, then display "Yes" in another field.

 

[Keith Wilby]

Hi...I am looking for a way to do the following:
When entering a part number into a form, I want the program to "look" at
the
part number, and determine if that part number is in a list of part
numbers
on a table, and if it is, then display "Yes" in another field.

Can I ask why you want this functionality? It may be that someone can
suggest an easier alternative.

Keith.
www.keithwilby.com

 

[Steve]

We are entering a ton of data into a form manually, and the person inputting
the data wanted the computer to automatically say "YES" if the part number
was a certain type of part number. The issue is that there are like 400 part
numbers that she wants it to say "yes" to if that part number is input.
There are a total of 1500 part numbers.

 

[Keith Wilby]

We are entering a ton of data into a form manually, and the person
inputting
the data wanted the computer to automatically say "YES" if the part number
was a certain type of part number. The issue is that there are like 400
part
numbers that she wants it to say "yes" to if that part number is input.
There are a total of 1500 part numbers.

In that case can I suggest using a combo box? Include a combo box on your
form and set its Row Source to the lookup table field containing the part
numbers. Bind the combo to the part number field in the main table. Start
typing a part number in the combo box and, if it exists in the lookup then
it will appear automatically. You could then use the combo's "On Not In
List" event to handle what happens if the entered number is not in the
lookup table.

Will that help?

Regards,
Keith.
www.keithwilby.com

 

[Steve]

I'm not sure if it will work or not...I will test it out. THANKS!