• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

Form and database optimization

I have the entry form shown in the attached screenshot that does not have a very nice layout.  Ideally, I would like the entry form to show all the records with the most recently added ones at the top. optimize form view
0
rtod2
Asked:
rtod2
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
use a query based on the table that you are using as the record source of the form,
in the query use an order by clause, something like this

select * from TableName
Order by ID Desc
0
 
Ariful AmbiaHead of ITCommented:
What problem you are facing to doing it?
0
 
rtod2Author Commented:
I was more talking about the form design to begin with.  What type of form should be selected.  I see that the answer to that question is continuous.
0
 
rtod2Author Commented:
rather not create a query
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now