Help with sorting in Access

  • Thread starter Thread starter natasha
  • Start date Start date
N

natasha

Hello,

I have a loan form I created with access. It has one field
which is a lookup to another table of customers. Recently,
I added new customers to the table. When I try ro create a
new loan now, the new customer entries are listed, but
they're not in alphabetical order. I tried sorting the
field on the form and put table itself in alpabetical
order. What can I do to make this field update??

Thanks,
natasha
 
Hello Natasha,

Presuming that the lookup field into your table of customers is a ComboBox
(or ListBox)... have you tried making the Row Source a query string based
on the table instead of the table itself? For example, you could make the
Row Source:

SELECT * from tblCustomers ORDER BY CustomerName;

hth,
 
You can invoke the query builder by opening the combo box into the
properties window. On the record source section invoke the ... (Ellipse).
Add the fields you need to sort by in the window. Save the file. Any new
entries will order automatically.

For order on the entire form, open the Form properties and invoke the Query
builder and do the same. Be sure to add all the fields as this is the same
as creating a separate query to use for data entry and attaching to the
form. The beauty of doing it this way is that you don't have individual
queries cluttering up the database window. Everything is processed within
the form.
 
Back
Top