Filling in a text box automatically based on a selection in a previous combo box
Posted on 2012-03-22
I have 5 fields in a table: Consignee (to), Consignee street, Consignee city, Consignee state and Consignee zip. All the information for each record has been entered into the table. I then created a main table and created a field called Consignnee (to) in it and made it a combo box that points back the Consignee (to) field in the first table so that i have a drop down box for users to select from instead of typing everytime. When a user selects a name from the Consignee (to) box on the form i need the other 4 fileds to be filled in automatically based on their selection in the Consignee (to) box. I have the field in the table set to column 1 as containing the data for that field and the column count set to 5. On the form i have all the fields showing and in Consignee Street i have the control source set to me.consignee_to_.column(2). When i open the form and select an answer in the Consignee (to) the Consignee Street just shows Name# in the field and not the address.