Look in the appropriate table(s) for the existance of the customer code in the LostFocus of the textbox used for entry. If it's not found, INSERT the new code.
>I have a form called order entry form, When i enter the information
>then i discover that i forgot to add a new customer therefore i click the button to call customer form popup then i key all the customer details, i close it. I want that new customer code to be inserted into
>the customer code field in the order entry form. Sorry for my english.
>hope you understand it. Thank You.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05