Hello and Good day.
I have a Main Form composed of multiple text boxes (Name, ID, Address1 and Address2) to fill information, a single combo box and a SubForm (Named SubFormTest). Lets say I got a database with 3 tables (Labeled Tbl1, Tbl2 and Tbl3), each with the information of different people, the idea is to submit information on the Form's text boxes, but I would like to let the user to autofill if the data exists already, that is the purpose of the SubForm, with a OnClick event in the SubForm, I am able to fill the textboxes whenever the user clicks a row on the SubForm. The Combo's purpose is to change the SuBFormTest's SourceObject whenever the user changes its value, because the information might not exist in Tbl1 but in Tbl2 or Tbl3.
At the start the OnClick event works perfectly, whenever the user clicks a row all textboxes are filled, the problem lies is when the user changes the value of the ComboBox, the table does indeed change the SourceObject to another table, but the OnClick event stops firing at all, even if I change the SourceObject to the original Table the SubForm displayed it won't work.
I have tried to find a solution to this but can't really spot an answer, apreciated if it can be solved.