Form and database optimization

Posted on 2011-10-29
Last Modified: 2012-05-12
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
Question by:rtod2
    LVL 119

    Expert Comment

    by:Rey Obrero
    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
    LVL 4

    Accepted Solution

    What problem you are facing to doing it?

    Author Comment

    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.

    Author Closing Comment

    rather not create a query

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now