Hello,
I'm new to designer, and I'm trying to make a form in which there is a table with multiple rows. The fields in each row are populated by a drop down list in the first column of each row. The drop down list is populated by a Microsoft Access database, and everything is all right with the connection and selection functions there.
But when I select an item from the drop down list and it populates the text boxes in the row, it also populates ALL text boxes bound to those columns in my database. How can I make it so that when I select an item from the drop down, it populates ONLY the textboxes in its row independently as opposed to all rows everywhere?
Tearing my hair out here! Thanks for any help.