J
J in KC
I have an entry form (form 1) that is based off of (enters into) a table
(table 1). Table 1 has the fields name, phone, etc. I also have a reference
table (table 2). Table 2 has the fields name and phone.
I have a drop down box (name) on form 1 that is based off of table 2 (sql
statement). I have a another text box in my form (phone) that I want to auto
populate. I want it to base off of table 2 but populate into form 1
automatically and therefore write to table 1. How do I do that?
(table 1). Table 1 has the fields name, phone, etc. I also have a reference
table (table 2). Table 2 has the fields name and phone.
I have a drop down box (name) on form 1 that is based off of table 2 (sql
statement). I have a another text box in my form (phone) that I want to auto
populate. I want it to base off of table 2 but populate into form 1
automatically and therefore write to table 1. How do I do that?