hi browning You may use two combo box for the data entry purpose both combo should be bound to the same data field
use a query in the first combo showing the item names (As you are al ready doing) use right function in the other combo say the table is item_table and the filed is item_name and its length is 40 text use this query in the combo raw/source property "select right (item_name,37) from the item_table;" when you will select some thing from this list it will be showing the complete name of the same thing in other combo Hope this will solve your problems irshad - Pakistan --- In [email protected], "Keith Browning" <[EMAIL PROTECTED]> wrote: > > Hi all, > > Is there a way when selecting an item in a combo box, that the first item > that pops up when the first characters are typed can be jumped past. Like a > "next match" key. > > My (stock item) list has several similar starting matches, such as > "microphone" and can become a bit tedious typing the lot in. > The list is sorted by record number which I also use as stock item number. > If I know the number, which is most times, I can locate it in the list > quickly. but.... > > Some way of typing "mic" then a next button a few times would be nice. > > Any ideas or am i dreaming ? > > Keith Browning > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
