entering data into a form

N

nathan

I have a problem when entering records into a form. After
they have been entered they seem to order themselves in no
particular pattern.
Does anyone know how to set the form settings to either
list the records in alphabetical order or the order they
were added.
I have ordered the records in database view but it didn't
make any difference.
Please help
 
R

Rick Brandt

nathan said:
I have a problem when entering records into a form. After
they have been entered they seem to order themselves in no
particular pattern.
Does anyone know how to set the form settings to either
list the records in alphabetical order or the order they
were added.
I have ordered the records in database view but it didn't
make any difference.
Please help
Click to expand...

Base your form on a query that imposes the sorting you want. Tables are by
definition unordered.
 
T

Terri

If you right click on the small sqare in the upper left
corner of the design view a drop box will show . Choose
properties, the under the data tab choose order by and
input your chosen field. Terri
 
Top