'Form and Sub form save with only one button on MS Access

I want to add record with one button on form and sub form. it should remain on current record when cancel or not click button.Product Detail iNVOICE NO

New Products://i.stack.imgur.com/NYbiL.png

Invoice Form

saverecordautosavesubformrandomaccessfile


Solution 1:[1]

  • Go to design tab
  • Click and drag the button icon into the main form
  • A wizard should pop up, follow the wizard by
  • Picking Record operations(to the left),Add new record(to the right)
  • Click next(at bottom)
  • Check Text
  • Click next(at bottom)
  • Click finish(at bottom)

The images attached depicts the steps.

Step 1

Step 2

Step 3

Step 4

Final Output

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Sola Oshinowo

Related Questions