saving data in form

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Mubs
    New Member
    • Mar 2007
    • 77

    #1

    saving data in form

    i have a form in my database.. when i enter details on the form for some reason it doesnt save the data when i reopen it...


    how can i save all of my entries
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    1) Make sure the recordset type is Dynaset.

    2) Make sure your file isn't read-only.

    3) If all else fails you can either make a save button or save on close.

    Comment

    • MMcCarthy
      Recognized Expert MVP
      • Aug 2006
      • 14387

      #3
      Is your form bound to a table or a query?

      If it's a query is your query updatable?

      Comment

      • Mubs
        New Member
        • Mar 2007
        • 77

        #4
        my form is bound to a table but i have many combo boxes and calendars for different functions.... i have tried a save button also but it does not save all details on the form... it only save names and title fields.. it doesnt save any dates that i enter using calendar and also any prices....

        can any1 help asap...

        Comment

        • Mubs
          New Member
          • Mar 2007
          • 77

          #5
          i have manged to do it

          thanx for ur replies

          Comment

          • Rabbit
            Recognized Expert MVP
            • Jan 2007
            • 12517

            #6
            How did you end up solving it?

            Comment

            • Mubs
              New Member
              • Mar 2007
              • 77

              #7
              Originally posted by Rabbit
              How did you end up solving it?

              i realised that some of the fields control source was not defined..

              Comment

              • NeoPa
                Recognized Expert Moderator MVP
                • Oct 2006
                • 32669

                #8
                Originally posted by Mubs
                i realised that some of the fields control source was not defined..
                As you've already discovered, only the bound controls of a bound form are saved. A bound form with unbound controls will not save the unbound ones.

                Comment

                Working...