Verifying content against a table

[sroot]

I have a simple database that a user records the work they have done for the day. They are required to fill out the form with the item number, date, qty etc... the problem is some people are fat fingering things and i am not getting the right item numbers... I have a table called dbo_item with all the possible item numbers in it, is it possible that after they hit enter or click off the item number box it will tell them they put in an invalid item if it doesn't match one of the items from that table? Thanks

 

[jdraw]

Often designers have a form with a listbox/combobox of valid entries and the user simply selects the item from the list. No typos.

You can validate an entry before accepting it to your database.

 

[sroot]

i would not want a list box as there are about 50,000 different item numbers

 

[jdraw]

Are your items categorized? You could have a comboboxes and use cascading combo approach. Another option is Find as you type from Allen Browne.