I need to get advice on how to make a text field that not only updates an
Access table with new entries, but also looks up existing entries in the same
table. Is this possible using a text field or menu drop down?