For some reason cant quite wrap my brain around what should be a relatively simple problem.
Scenario:
User enters their login name in a field on a form. The form name is Login and the field is Text1. User clicks on a button, called Command1. Based on Text1, the form looks at the matching Associate field (ie, user enters michael and the record where Associate field is michael is selected) and its corresponding Pref1 field both which are in Table2. The Pref1 field holds a variable that determines which form opens up.
I presume the above is done with VBA for the Onclick event for Command1. What would the code look like? I realize a combo box would be easier than a text field but Im trying to make the db a little more secure by not displaying everyones login name.
Thanks in advance.