Viewing records in Form View

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • bexta23
    New Member
    • Aug 2007
    • 4

    Viewing records in Form View

    Hi. New to this, but hoping somebody can help me!!!

    I have created 4 tables, and a form which links to these tables. I want to be able to view all the records as a form, but can't seem to work out how to do this. The tables are all linked to one another via Relationships.

    Please help!!!
  • kathnicole
    New Member
    • Mar 2007
    • 33

    #2
    Originally posted by bexta23
    Hi. New to this, but hoping somebody can help me!!!

    I have created 4 tables, and a form which links to these tables. I want to be able to view all the records as a form, but can't seem to work out how to do this. The tables are all linked to one another via Relationships.

    Please help!!!

    Hi,

    Use the Form wizard to create a form.
    Click Form
    Select "Create form using Form Wizard"
    Follow the promts.

    it is as simple as that.




    chuz,
    Kathy

    Comment

    • bexta23
      New Member
      • Aug 2007
      • 4

      #3
      That is how I managed to get the Form to start with. I can enter data into the form and it will flick it off to each table. But when I re-open the Form, none of the data is there (but it is still listed in the Tables).

      I want the form to display all the data I have already entered...

      Comment

      • bexta23
        New Member
        • Aug 2007
        • 4

        #4
        I will just add that I am using Access 2007... Which appears to be a completely different program to 2003 which I knew like the back of my hand!!!

        Thanks

        Comment

        • missinglinq
          Recognized Expert Specialist
          • Nov 2006
          • 3533

          #5
          In Design View of the form goto Properties - Data. Is the Data Entry property set to "Yes?" If so, set it to "No." Also make sure that AllowAddiions, AllowEdits and AllowDeletions are set to "Yes."

          Welcome to TheScripts!

          Linq ;0)>

          Comment

          • bexta23
            New Member
            • Aug 2007
            • 4

            #6
            Data Entry is set to NO, AllowAdditions, AllowDeletions, AllowEdits and AllowFilters are all set to YES and I still have no luck...

            It just shows me a blank form, even though there are plenty of records entered.

            Comment

            Working...