Combo boxes

[Guest]

I have a form linked to a customer table.
I have a customer id that is an Autonumber and a customer name along with a
whole host of customer detail.
The first field on my form is a combo box that contains a list of company
names.
These are sorted into Company Name sequence.
When I select the different companies the data shown on the form changes
correctly.
The trouble is that when the form first loads it contains data in the detail
fields for the customer id = 1 and the Company Name that this refers to in
the combo box is blank.
Is there any way of getting the first alphabetic company name to appear in
the combo box along with the correct details ?
Any help would be appreciated.
Though this is not a show stopper it's bugging me as I can't work out how to
do it !!!
Cheers

 

[Guest]

Try setting the defult.

 

[Guest]

Wow,
Wonderful response!!!
I wrote war and peace.
You write 4 words. What is a defult? and what do you mean exactlly?
Can you be a little more explicit please?
Thanks

 

[Guest]

Open the form in design view and click on menu VIEW - Properties. This opens
another window.
Click on the ComboBox. Enter the number that corresponds to the Company
Name in the line beside Default.
Close the Properties window. Save. Open the form.

 

[Guest]

Thanks Karl,
The problem is that the Combo box is populated with Company Names that have
been sorted as part of the Select Query.
I do not know the CustomerID of the first Company Name.
I could cheat and look in the table and then put this in as the default as
you suggest, but this would not be correct once the user enters a new Company
Name that comes first in the alphabet.
Thanks