A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combo Box Wizard problem



 
 
Thread Tools Display Modes
  #1  
Old November 22nd, 2007, 07:07 PM posted to microsoft.public.access.tablesdbdesign
Francis Cunningham, Jr.
external usenet poster
 
Posts: 37
Default Combo Box Wizard problem

Selecting the Combo Box Wizard's third item ‘find a record…’ I’ve noticed
that the resulting combo box is actually sorting based on the Key column
(ContactID 1, ContactID 2 and so on in that order) which is hidden and not
the ‘Last Name that’s desired. This method as the last record entered being
the last item in the combo box pull down list. I created this combo box so we
may type in the customers Last Name and the resulting list is Last Name
alphabetic order (type in ‘Smith’ and all the Smiths appear) How can I make
the combo box sort based truly on the Last Name.
Frank
Happy Thanksgiving
  #2  
Old November 22nd, 2007, 07:34 PM posted to microsoft.public.access.tablesdbdesign
Ken Snell \(MVP\)
external usenet poster
 
Posts: 2,506
Default Combo Box Wizard problem

Go into the RowSource property of the combo box, and change the field name
in the ORDER BY clause to the one on which you want the sorting to be done.

--

Ken Snell
MS ACCESS MVP


"Francis Cunningham, Jr."
wrote in message ...
Selecting the Combo Box Wizard's third item 'find a record.' I've noticed
that the resulting combo box is actually sorting based on the Key column
(ContactID 1, ContactID 2 and so on in that order) which is hidden and not
the 'Last Name that's desired. This method as the last record entered
being
the last item in the combo box pull down list. I created this combo box so
we
may type in the customers Last Name and the resulting list is Last Name
alphabetic order (type in 'Smith' and all the Smiths appear) How can I
make
the combo box sort based truly on the Last Name.
Frank
Happy Thanksgiving



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:45 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.