Trying to create a simple form where selecting from pop-menu displays matching record
It's more than a little frustrating because I know how to do this in Access but I have been halfway through "The Missing Manual" and can't figure this out.
I have a table of users. I have a form with all the fields from that table. I want to create a field with a pop-up menu listing my twenty users. When I click on the desired user, I want the form to display the record matching that user.
I tried making a separate named field "DropDownUsers" and having it display the list of users. Then, I made a button which performed a find but I can't figure out how to get the data from "DropDownUsers" into the "Users" field selected for the find. There must be a way to tell the find to look in Field A for records matchign Field B.