Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / February 2005

Tip: Looking for answers? Try searching our database.

Finding a record on a from with a combobox

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kathy G - 09 Feb 2005 17:09 GMT
I have used the wizard to set up a combobox to finda a record on my form by
the name of the examinee we are testing.  I told it to use the lastname,
firstname, and middlename.  I then told it sort the records in ascending
order.  The box works fine when there is only one Baker, or Davis but if
there are 2 or more it will only take me to the first one listed.  How can I
make it take me to the one I pick?

Thanks in advance for the help
Chris Reveille - 09 Feb 2005 18:26 GMT
I assume you have a primary key.  The combo box should be
set up in the order
PrimaryKeyField
lastname
firstname
middlename
You can hide the PrimaryKeyfield
and sort by lastname, firstname, and middlename

Chris

>-----Original Message-----
>I have used the wizard to set up a combobox to finda a record on my form by
[quoted text clipped - 6 lines]
>Thanks in advance for the help
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.