Sep 29 2022 06:40 AM
Very infrequent user of Access, so bear with me.
I have two tables and one form. On the form, I have a combo box to select a field from Table 1, and save the selected value in the same field in Table 2. Easy to set up, no problem.
What I would like to do is to be able to use a combo box to select a value from Field 1 of Table 1, but also automatically bring over the values from Field 2 and Field 3 of Table 1 and store them in Field 2 and Field 3 of Table 2, based upon the selection of Field 1 of Table 1 by the combo box.
Suggestions? Thanks!
Sep 29 2022 07:15 AM
Oct 01 2022 10:17 AM