Which Qry or Tbl link to a Form

Posted on 2012-08-13
Last Modified: 2012-08-13
Hi Experts

What's the quickest and simplify way to find out which Qry and Tbl link in any particular form
In a acces db.

ie where is the data coming from to drive the form.
Question by:route217
    LVL 47

    Accepted Solution

    The form has a RecordSource property, on the data tab of the Properties dialog box.

    Author Comment

    Many thanks for the feedback
    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)
    Glad I could help.


    With a form, if you want the records to show in a particular order, other than the order of the primary key, you will need to create a query, and sort by the appropriate field(s).

    In a Report, this sorting in the query has no effect, you will have to define any sorting in a report by using the Grouping and Sorting functionality within the report itself.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    760 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

    11 Experts available now in Live!

    Get 1:1 Help Now