Making data entry easier....

[egg]

Hi I have a field in a table which is set to text, diplay control=list box, row source=value list. Row source = "level1", "Level2" etc up to "level9".

Now the form for new records matches this except the values allowed are limited to the list, ie they can only enter exactly one of the list above or it throws user an error.

My question is how can I make it easier for the user to input data, ie instead of having to type all the word 'level1' can i get it to accept also the number 1 to 9 and then auto change the value to the correct field ie if user enters 1 it auto changes it to level 1. But i still want it to limit what the user can put in so to get 'level1' entered they can enter '1' or 'level1' (or select from drop down list) but not accept anything else?

Thanks in advance

 

[RuralGuy]

The Evils of Lookup Fields in Tables

 

[egg]

Interesting....

So what do you suggest instead?

 

[RuralGuy]

Control all of your data entry with controls and code on a form.

 

[egg]

Ok Ill give that a whirl thanks for all your help