strange... perhaps no need a dropdown, just have one textbox txtID then after update use dlookup and display the name on your txtName if found otherwise view msg...
hth George -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Ralph Sent: Monday, October 09, 2006 6:38 PM To: [email protected] Subject: [ms_access] Re: drop down box George, 145 would be one record ID. Normally in the drop down they would scroll to the record they wanted. With 20,000+ records it isn't practical. So they would just like to enter the record ID and have a name display. It only allows for 1 character to be entered at a time in the drop down box... if I enter a 1 (145), I need to click after the one to get the 4, then click again in the box to get the 5. Ralph --- In [email protected], "George Oro" <[EMAIL PROTECTED]> wrote: > > 145 is one ID number or combination of 3 ID's? > > check the source or the properties... > > > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] > Behalf Of Ralph > Sent: Friday, October 06, 2006 9:38 PM > To: [email protected] > Subject: [ms_access] drop down box > > > Hi, > > I'm using a drop down box to bring back a record ID from a persons file. > Once it gets the ID it then reads the name of the person and displays > it on the form. > > It the user wants to enter the ID number rather than use the drop down, > they can only enter 1 numeric character. To enter more they need to > click after each number. So it it's 145, they would enter a 1, then > click behind it, then etner a 4, click, 5 click. > > I don't understand why they just can't enter 145 and then press Enter. > > Ideas? > > Thanks, > Ralph > > > > > > > > > Yahoo! Groups Links > Yahoo! Groups Links 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/
