This one is very tricky, but if anyone has any ideas I will greatly appreciate it.
I have subform, that has a drop down list on it. After the user selects from the drop down list they want two other text boxes to auto populate with the fields that relate to that choosen item in the original drop down list. What makes this tough is that there are multiple records of each drop down item, and the users agreed to auto populate the two fields with the related information in the 1st instance of that drop down item.
Example
Animal: Cat Attributes: Fur Weight: 13 lbs.
Animal: Cat Attributes: Meow Weight: 15 lbs.
But Can only shows up once in the drop down, and I want the other two boxes to update to the 1st instance of this drop down (Recordset) so update Attributes: Fur and Weight: 13 lbs.
any ideas of where to look?
Thank you for your time,
T.J.
I have subform, that has a drop down list on it. After the user selects from the drop down list they want two other text boxes to auto populate with the fields that relate to that choosen item in the original drop down list. What makes this tough is that there are multiple records of each drop down item, and the users agreed to auto populate the two fields with the related information in the 1st instance of that drop down item.
Example
Animal: Cat Attributes: Fur Weight: 13 lbs.
Animal: Cat Attributes: Meow Weight: 15 lbs.
But Can only shows up once in the drop down, and I want the other two boxes to update to the 1st instance of this drop down (Recordset) so update Attributes: Fur and Weight: 13 lbs.
any ideas of where to look?
Thank you for your time,
T.J.
