cellulargnome
New Member
- Joined
- Mar 30, 2017
- Messages
- 15
OK, I'd love to say I've had a go at this but to honest I don't even know where to start with the text boxes.
I have a combo box populating it's items from an Access database, This i'm doing using getrows and it populates fine.
The problem I have now is with the text boxes. Each row in the combo box is just the one column "EmployeeName" (It's a small list). Each row has other columns with data I want to display in text boxes but that where I get lost. So Column2 "BuildingName" would go in TextBox1 and column3 "EmployeeExtension" would go in TextBox2. I need this to change as the combo box selection changes. I thought about just creating a form within the Access database but not all pc's have Access installed, plus I'd rather not have to leave the Excel file.
Many thanks in advance
CG
I have a combo box populating it's items from an Access database, This i'm doing using getrows and it populates fine.
The problem I have now is with the text boxes. Each row in the combo box is just the one column "EmployeeName" (It's a small list). Each row has other columns with data I want to display in text boxes but that where I get lost. So Column2 "BuildingName" would go in TextBox1 and column3 "EmployeeExtension" would go in TextBox2. I need this to change as the combo box selection changes. I thought about just creating a form within the Access database but not all pc's have Access installed, plus I'd rather not have to leave the Excel file.
Many thanks in advance
CG