Order form problem

[boblarson]

Tried that and it made no difference (I only added that so i could get the supplier name to show)

Funny, works for me.

 

[boblarson]

 

[Gazza2]

Sorry bob but ive been a complete idiot and realised why i couldnt get it working like you have.

I was using the FrmPOSupplierSelect form to select the supplier and copy it to the FrmPurchaseOrder2 form and the SupplierCode was not regestering on the new record which is why i was getting that error.

If i just open up FrmPurchaseOrder2 and enter the supplier code manually it works fine.

 

[boblarson]

If i just open up FrmPurchaseOrder2 and enter the supplier code manually it works fine.

That's good, but I still would hate to be one of your users (unless you are the only user). They will need to know every supplier code and every product code since you won't let them select it with a combo box. That would get you some real nasty looks and comments from most users I've known. The idea as a developer is to make the user's life easier when designing a User Interface, and functionality should take precedence over the look.

 

[dcb]

Listen to bob here - even if you have made this only for yourself.
There are things I have had to learn the hard way with my users
Some of them love being able to click things and have pop ups - click click click - these users will hate you if they have to click type click;
Some of them (your more accounting type of user) hates the mouse as they want to enter data at speed - if they have to click you are doubling their time - they want to be able to navigate the GUI with Tab and the keyboard.

Look at your end user requirements rather than the aesthetics especially in a order form where most likely your user is on the phone whilst doing the data entry...

you can use some simple code to get the supplier code accross

 

[Gazza2]

Ok consider me told off.

This order form is a two part form which instead of a combo box for the supplier code i was using a kind of search form(FrmPOSupplierSelect) to select a supplier based on the first few characters and then copy this across to the order form and then they can go straight to entering products without using the mouse atall.

The idea i was using was not to use the mouse atall, only the keyboard.

P.S. I am only just beginning with access and am using the sales app from work as a guide which uses only the keyboard.Once i have the general idea working then i can take all the advise i have been given here and in other posts to make it better but im stubborn and like to make things work the way i want first no matter how hard it is.

Thanks
Gareth

 

[dcb]

Not trying to tell you off at all - Just some learnings I have had (and from Bob's comments he has had too)

I wouldn't scrap the search box idea completely though... sometimes finding something in a Combo box can be really difficult and maybe this form could be usefull as a second option - maybe double click the combo box?

A common example that I deal with in ACCPAC is "some little company t/a some other truly cryptic company"

 

[boblarson]

The interesting thing about a combo box is that if you set AutoExpand to YES it will start finding the item as you type, so you don't need use the mouse for the combo. You just start typing the first letters and it finds the item you hit tab or enter and you're on your way. No other search form has to popup or anything.