Form Field needs to click button and open info about first/last name

[incognito]

I need to set up a command button so when they put a first and last name into a text box, it separates them so the names can be looked up in fields, and then pull up the cooresponding information in a new window of the same form.

 

[RickSpr]

Name parsing is a major problem in Information Technology. Many names work fine, but sometimes you have a Mary Beth Williams (2-part first name) and other times an Anders ver Olafsson (2-part last name). If your users would be willing to use special punctuation to separate first and last names, it's much easier. "Last, first" might be acceptable. Otherwise, I'm afraid you're going to have to make several attempts to parse the name, and maybe even accept some false matches.

But I have to ask you why you want a "new window of the same form"? That's quite a nonstandard approach. It's possible, I think, but takes more coding than using the default instance of the form. Couldn't you just display the data in the same form? Rick Sprague