https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/2876.aspxMon, 31 Jul 2006 19:21:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:2876Greg Collins0https://www.infopathdev.com:443/forums/thread/2876.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=2876If you do want to do this in code, the "lost focus" you are talking about is really the OnAfterChange event. Do a little research on this event and how to use it.https://www.infopathdev.com:443/forums/thread/2875.aspxSat, 29 Jul 2006 16:34:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:2875Matt Faus0https://www.infopathdev.com:443/forums/thread/2875.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=2875Hello Eric and welcome to the forums!<br /><br />You should be able to accomlish this without writing any code. I have written a HowTo on doing this with a Drop-Down list box, but you should be able to follow it pretty closely and apply the same logic to a text box. It would probably be even easier.<br /><br />After you have the fields populating like you want to, you can add a button to submit the query to your DB.https://www.infopathdev.com:443/forums/thread/1450.aspxSat, 29 Jul 2006 13:52:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1450ciredon0https://www.infopathdev.com:443/forums/thread/1450.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1450To Anyone that could help.<br /><br />I'm new to infopath. Can anyone give me a sample code for me to get the idea on how to perform codes in InfoPath using VBScript.<br /><br />What I wanted to do was: I input data into a textbox (Employee Number), then when control is lost (LostFocus())from the textbox it will search a secondary database (Employee Information). When a record in the database matches it will display the corresponding employee information like department, telephone number, last name & first name into corresponding read-only controls in the form. Afterwhich I can submit the final content of the form into the Main database.<br /><br />Q1: Is this logic possible to be implemented?<br />Q2: Is is true to assume that the controls in the form should be binded to fields in the Main database yet data displayed in these controls comes from a secondary database or from a variable used in coding?<br /><br />Thank you in advance.