Before I begin with my question, I know this is convoluted. I could figure out a much better way to do this, but unfortunately I am attempting to make a mockup of portions of an existing program for training purposes and it was programmed by nitwits. Not that I am much better, but I shouldn't be paid to program anything...
But I digress.
What I am working on that has got me in a bind right now is this.
I have a form that opens when I press F4 in another form. This pulls up a window with a subform inside drawing information from a table with three fields, Select, Code & Description. What I need to happen is, when the user puts a "1" in the select field and presses Enter, the program takes the item in the code fields that corresponds to the "1" that was entered under select and opens a form of the same name (say ENTNAME for example) discards the "1" entered on the subform and closes the selection form. It would also have to kick back an error if there were anything other than a "1" in a select field or more than one "1" entered (referencing two or more codes)
This is what the form used to select the code currently looks like:
I appreciate any ideas. This went a bit over my head. Thanks!