I have 3 populated fields in 2 tables: Field A1 in Table A, and Field B1 and Field B2 in Table B. I have created a form which will populate another field (Field A2 in Table A) based on users' selections from a list box, with the response options (i.e., row source) extracted from Field B1. However, Field B1 and (in following) Field A2 are text fields. To facilitate some analyses, I also want to record the ID code (Field B2) corresponding to Field B1.
Thus, when a user makes a selection that populates (text) Field A2, I want the (numerical) Field A3 to be populated with the corresponding ID code. I imagine this requires a query, but query development is the weakest part of my very spotty, limited knowledge of Access.