How do I create a Form in Access to automatically update my table fields?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Kelly Warden
    New Member
    • Sep 2010
    • 7
    #1

    How do I create a Form in Access to automatically update my table fields?

    I want to create a form in Access to update my table automatically with the information selected from combo boxes, lists, comments, etc.

    Also, I want to automate this w/ some VBA or SQL or something in Access. I want to be able to automatically fill out parts of the form based on some other tables containing different data.
    Basically in the form, if reason 1 is automatically filled out then its done and no one needs to look at it and it updates a specific table. If not reason 1 then it looks down to reason 2, reason 3, etc..

    If no reason is found then the unique ID goes to a table and someone manually goes in to look at those records.

    Please HELP!

    Thanks!
    Tags: access, automate, form, forms, vba
    • Stewart Ross
      Recognized Expert Moderator Specialist
      • Feb 2008
      • 2545
      #2
      Sorry, Kelly, but you need to do some detailed design work before we or anyone else can help you. Spend some time defining your table structures first, and their inter-relationships (the 1-many relationships that are bound to exist between your tables if you design things properly).

      You may find this article on database normalisation and relational table structures useful to get you started.

      -Stewart

        Comment

        • Kelly Warden
          New Member
          • Sep 2010
          • 7
          #3
          I already did that work. I am looking for a simple approach I can use as a guideline. I am not looking for an exact answer. I want to know after things are set up how do I go about creating the above.

          Thanks!

            Comment

            • Stewart Ross
              Recognized Expert Moderator Specialist
              • Feb 2008
              • 2545
              #4
              I do understand your frustration, but there is no easy answer I or anyone else can give you. As a developer myself, all I can tell is you that you must be able to define your requirements much more clearly than you have in post #1.

              Access development is a very broad theme, and as it stands there is little I could do to assist you other than in the broadest of generalities.

              There are many good texts on Access development, and one I'd recommend is John L Viescas' book Building Microsoft Access Applications as a good place to start.

              -Stewart

                Comment

                • Mr Key
                  New Member
                  • Aug 2010
                  • 132
                  #5
                  Mr Stewart is right, If you are new to this forum you are welcomed. Be free to mention each and everything you need, Ofcourse you dont have to tell us in details about your tables and database for real but only hints (including tables, form contents, Events and the requirements of your design)that you might think enough to explain your problem and be able to get answers.
                  You may not receive enough response just because no one understand your question.
                  I suppose you ask your question again!

                    Comment

                    Previous template Next
                    Working...