I need help on Access 2000. Creating a form to save new records.

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Daniel B
    New Member
    • Aug 2010
    • 33
    #1

    I need help on Access 2000. Creating a form to save new records.

    I am building a database and I would like to create a form based on several tables that allows me to enter data for a new record, save it, and store it back into the original tables. Any comments or advice would be much appreciated..

    I also have a deadline for this project, and I need to have most of this done by Monday, Aug. 16!
    Tags: None
    • mshmyob
      Recognized Expert Contributor
      • Jan 2008
      • 903
      #2
      Since you didn't ask a specific question but just want advise... I have always found that when using a form that has to reference data from multiple tables I find it easiest to create a simple SELECT query that has all the fields from all the tables I want to work with in the form and then bind the form to the query.


      cheers,

        Comment

        • NeoPa
          Recognized Expert Moderator MVP
          • Oct 2006
          • 32669
          #3
          Good advice.

          You may want to check out Reasons for a Query to be Non-Updatable to ensure your query stays updatable.

          Welcome to Bytes!

            Comment

            Previous template Next
            Working...