Combo Box Query

[Guest]

Hi

I run Win2k and Access 2K

I have a form that contains a combo box that looks at a table called
"tblAddNames". This combobox works fine but does not show the list in
alphabetical order. So, I have created a query called "qryEmployee" that
sorts the names alphabetically. The problem I have is that I dont know how I
should reset the combobox properties to read the query instead of the
tblAddNames table.

Can anyone help?


Thanks

John

 

[Granny Spitz via AccessMonster.com]

The problem I have is that I dont know how I
should reset the combobox properties to read the query instead of the
tblAddNames table.

Open the form in design view and right click on the combo box, then click
Properties. Click on the data tab, then use the combo box for Row Source to
select your new query. Save and open in form view.

 

[Guest]

Thanks for your prompt response.

I have done as you said and now when I use the combo box on the form to view
the names it is empty?

The query seems to work ok by itself when I look at it. All the names are
alphabetical and look ok.

What am I doing wrong?

Thanks

John