Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Saving unbound forms


Message #1 by "Andrew Payne" <andrewpayne.plastics@b...> on Thu, 18 Apr 2002 17:17:02
I have a form where all the text boxes are unbound, i need to do this to 
enter or manipulate data from other forms into them upon opening.  Once 
the all the data is there i need to be able to save the form, edit some of 
the data and clear other parts, I can do all this fine but the data does 
not want to save to the relavant table untill the form is closed.  This 
also has the effect of only the last set of data gets saved.
To save I have been using the docmd:

           docmd.save , "frmNewDeliv"

Is this the correct way to use the command or can someone suggest another 
way to save the data to its table.

Thanks 
Andrew

          

Message #2 by "Andrew Payne" <andrewpayne.plastics@b...> on Thu, 18 Apr 2002 17:20:05
I forgot to say that i bind the data to the form by using the follow lines 
of code before saving   
    Form_frmNewDeliv!CustomerID = txtCustID
    Form_frmNewDeliv!Quantity = txtQuantity
    Form_frmNewDeliv!OrderNo = txtOrdNo


  Return to Index