Search results

  1. J

    Saving information from form to a different table?

    Private Sub Save_and_Close_Form_Click() RunCommand acCmdSaveRecord DoCmd.SetWarnings False DoCmd.RunSQL "INSERT INTO [Pupilstudiestbl] SELECT * FROM [pupilstudiesfrm] RunCommand acCmdDeleteRecord DoCmd.SetWarnings True End Sub I have tried to use this to save my unbound fields to a table but...
  2. J

    Saving information from form to a different table?

    anyone? :(
  3. J

    Saving information from form to a different table?

    Hi Isskint Thank you so much for the response its much appreciated! I just need to be able to do it as part of my coursework so if you could elaborate on how to do it any way you would be a life saver! btw I have some knowledge of VBA and some SQL but both are limited :(
  4. J

    Saving information from form to a different table?

    Hi everyone I have created a form and a subform within it, I have managed to populate all the dropdown boxes from the tables I need. but I need to save all the information in putted to a table called bookingstbl and I do not know where to begin? Regards James
Top Bottom