Microsoft Office Access 2003 (077-02871) for PC Logo

Related Tags:

Problem with Microsoft Office Access 2003 (077-02871) for PC

My opening screen is linked to main table in db. I have set each field to locked so users won't edit in error. I added an "Add, Delete or Edit" button to open an almost identical screen

that can be edited. Both are bound to the same table. When the second form opens, no records show up, but the user can add a new record. I want it fully populated so the form can be used to edit existing records. I assumed that the problem was the other open form, so I added a macro that first closes the original form, then opens the editable version. Still no records. I can open it directly from the list of forms and it populates correctly. Data Entry is set to No and Recordset type is set to Dynaset. How to fix? Thanks

Posted by avatar on Jul 04, 2009

    • By avatarellen1460 Jul 05, 2009

    • I finally figured it out myself--the second form was set up as "dialog" rather than normal in the macro.

Solutions (1)

Change the "Data entry" Property to "No". This is what preventing you in viewing other records.

Add Your Solution

Microsoft Office Access 2003 (077-02871) for PC Unsolved Problems

See all Microsoft Office Access 2003 (077-02871) for PC Problems

Related Topics