Hi again, I have made another combo box and they track each other. (Neat) But... I can't get my head adding the right function to the query. I have tried in vain. The row/source is: SELECT [Part prices].[Part], [Part prices].[Model (s)], [Part prices].[Partcode], [Part prices].[price retail], [Part prices].[ID] FROM [Part prices] ORDER BY [Part prices].[ID];
[Part] is the description that I need to start typing. The box is bound to column 3, [Partcode] Any further help would be greatly appreciated. keith ----- Original Message ----- From: "irshad_ncs" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, October 02, 2006 9:21 PM Subject: [ms_access] Re: "more" on combo box. 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 __________ NOD32 1.1784 (20060929) Information __________ This message was checked by NOD32 antivirus system. http://www.nod32.com 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/
