Assening order of Combo box

[Mike Busch]

When I set up a combo box to find records within a form I set them up to look
for the LName and FName and I need them to have the whole list in assending
order. Right now I have a several lists for A - Z within the combo box. Any
help. Thsnk is advance.

 

[Douglas J. Steele]

Base the combo box on a query that has the appropriate ORDER BY clause.

 

[Mike Busch]

I would like to use this to find records in the form. If I select that in the
wizard it does not allow me to select a query, I can only use the fields in
the form. I have sorteed them from the Table that the form is from but it
does still not work.

 

[Douglas J. Steele]

Sorry, I never use the wizards, so I can't be certain.

Once you've got the combobox set up, you should be able to go back and
change its Row Source.