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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Excel file into Word Document 3
Add additional information to excel form after original data entry 0
Clearing combo boxes and a text box 2
Split form 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Crash on Close from 2 stable Access forms after unsolicited install of VS 2015 0
Creating a Search using a combo box and then creating a report. 4
Copy previous record into form field 0

Top