Accessing selected records from datasheet view Subform. access 2003

Posted on 2007-07-20
Last Modified: 2012-06-21

I'm creating database using Access 2003.

I need to create Form with subform (the subform is based on query) and i want it to use datasheet view.
After that I want to be able edit data inside subform or add some buttons on main for which allow me to edit selected rows from my subform,

How can I get selected data form subform ? (example please)
Can I edit data in datasheet view of Form based on query?

Best Regards
Question by:f_o_o_k_y
    LVL 119

    Expert Comment

    by:Rey Obrero
    <Can I edit data in datasheet view of Form based on query?>

    yes, you can, only if the query is not complex and  is updateable
    LVL 119

    Accepted Solution

    another way is to open another form in single view mode which will display the record's particulars that you selected from the sub form.

    this can be done in the click event of the form or the field.

    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

    Join & Write a Comment

    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    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

    25 Experts available now in Live!

    Get 1:1 Help Now