InfoPath Dev

To Anyone that could help.

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.

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.

Q1: Is this logic possible to be implemented?
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?

Thank you in advance.

Hello Eric and welcome to the forums!

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.

After you have the fields populating like you want to, you can add a button to submit the query to your DB.

If 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.