Problem in append table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • suriacute85
    New Member
    • Jul 2007
    • 6

    #1

    Problem in append table

    Hi,

    I'm very new in Ms Access, i have a form which contain a sub form table, i also have text box for data entry. when i enter the data, and click the add line button, the data will automatically save and view in sub form. the problem is, now, i want the data move to a new table and after that, the data in the subform disappear when i click button save.
    how can the data move to another table and the data will not view in sub form when i click the save button? Please help me.. I'm desperate.
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Originally posted by suriacute85
    Hi,

    I'm very new in Ms Access, i have a form which contain a sub form table, i also have text box for data entry. when i enter the data, and click the add line button, the data will automatically save and view in sub form. the problem is, now, i want the data move to a new table and after that, the data in the subform disappear when i click button save.
    how can the data move to another table and the data will not view in sub form when i click the save button? Please help me.. I'm desperate.
    Why have a subform at all then? Sounds like you can just use unbound controls and use a DoCmd.RunSQL "INSERT ..." on button click.

    Comment

    • suriacute85
      New Member
      • Jul 2007
      • 6

      #3
      i have another problem, in my form, i have a sub form which i take the record from my table T_LogEntry, after i click save button, i want the record in the sub from move to my another table called, T_EntryData. and automatically, the record in the sub form will disappear. will U help me?

      Comment

      • Rabbit
        Recognized Expert MVP
        • Jan 2007
        • 12517

        #4
        Originally posted by suriacute85
        i have another problem, in my form, i have a sub form which i take the record from my table T_LogEntry, after i click save button, i want the record in the sub from move to my another table called, T_EntryData. and automatically, the record in the sub form will disappear. will U help me?
        I refer you to post #2 because this is the exact same question.

        Comment

        Working...