AnsweredAssumed Answered

Trying to create a simple form where selecting from pop-menu displays matching record

Question asked by boydcrow on Nov 2, 2011
Latest reply on Nov 2, 2011 by boydcrow

Title

Trying to create a simple form where selecting from pop-menu displays matching record

Post

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.  

Please advise.

Outcomes