View Single Post
  #1  
Old December 20th, 2006, 04:48 PM posted to microsoft.public.access.forms
Steven Sutton
external usenet poster
 
Posts: 29
Default Making combo box display first entry in list

I am using two combo boxes to enter data into a table. The contents of the
second combo box list will change depending on the entry in the first combo
box. I have all of that working just fine. When I select something in the
first combo box, the second boxes contents get cleared and then I requery the
second box to get the new list. The problem I can't figure out is how to get
the second box to always show the first item in its list (after the its list
has been updated, of course).

Here's some more specific details in case it helps. There is a table
(tblNamesAndVersions) that has three fields - JobName, Version, VersionIndex.
Combo box 1 uses a query to get the distinct job names from the table. The
second combo box then uses a query based on the first combo boxes contents to
pull the Versions that are relevant to the JobName selected in combo #1. As I
said, all of this is working just fine. All I am wanting to do now is to make
the contents of the second combo box be the first entry in it list. Can
anyone tell me how to do this? Thanks in advance.