I have created forms in access with unbound controls which are all connected together as forms on tab. In order to populate the values in the unbound control on selecting "CID" (which is what is common among all tables) i have written the code in "On current" event of each form. This makes the whole process too slow which is annoying for the data entry person. I would like to know if there is a faster mechanism or way to speed up the process. Also i have written the code on each control's update event too, so as to write the updated value to the corresponding field each time its is updated. Could someone help me do this. Or is there a way to populate the unbound controls only when the corresponding tab is selected. Which event should i write the code on.