First we enter ID no in ID no's text-box and as soon as we click on command button made as SHOW DETAILS. Next we get the relevant data into our other text-boxes based on input the ID in the ID no-box. This process using VBA automates the complete process of retrieving data from a worksheet to the text-box and text-box controls of a user-form.
you can comment if any query.....
Thnx,
G Kumar