Hello, I have tried multiple methods here and I am stuck (kind of rusty at using access). I have a form bound to a query named qry_MAL_browwers and I want a list box on the form with two columns from the query to open a second form based on the selected criteria in the list box to edit the record. I can get it to work with one column in the list box but not with two. Any help anyone can provide would be very appreciated. Thank you.
List box name: LST_AdminCo_LoanNo
List box row source: SELECT [qry_MAL_borrowers].[Admin_County], [qry_MAL_borrowers].[Loan_No] FROM qry_MAL_borrowers;
Button name: Open_Edit_Record
Form to open: frm_MAL_borrowers_FormView