Creating Customer User Form

Originally Posted by jaslake

Hi kjelles

What's your data file look like...post an example. Should be able to build a UserForm thatNeed to know what the file looks like to build the form.

John

Hi, John & Thanks alot for your interest in helping out here! :-)

Basically I dont have anything yet, just the plan of how it should be working out.

Basically a few customers might for example have the very same comany name, but belonging to different contries. Therefor I'd like to see the search results narrowed on the fly to ASAP be able to pick the correct one.

And at the moment nothing is found I'd like to add a new one.

So basically, first a customer number. If the customer number is known you could type it directly into this box. If not you do the search for the company names. At the moment nothing is found you should be able to add this company as a new customer.

So Customer number - Name - Address-1 - Address-2 Zip code - Place and finally country.

The rest I think should be pretty plain business I'd guess.... :-)

Any similar sheet could be used for an example I'd think... :-)