Auto saving detail from Form fields in individual record to a subform and then clearing fields in main field.

Detectiveclem

Active Member
Joined
May 31, 2014
Messages
272
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
I am new to Access (Using Access 2013). For that reason please forgive me for my layman's terms to describe what I am trying to achieve.

I have created a 'Tasking' Form which records when tasks assigned to individual members of staff. The Form includes the following fields:-

  • Task number (1 - Upwards)

  • Priority level (Combobox -High, Medium, Low, No priority)
  • Status (Combobox - Live, Complete, Awaits allocation, Record only)
  • Allocated by (Combobox List of names)
  • Allocated to (Combobox List of names)
  • Date assigned (Date picker)
  • Target completion date (Date picker)
  • Actual completion date (Date picker)
  • Entry (Long text box)
  • Date of entry (Date picker)
  • Supervisor Comments (Long text box)
  • Entry date Supervisor (Date picker)
  • Other comments (Long text box)

What I am trying to achieve is when any entry is made and saved on any of the fields Entry, Date of entry, Supervisor Comments, Entry date Supervisor and Other comments that this information auto populates on to a subform shown within that same main form record and that all the fields shown in red default to clear ready for any subsequent entries under the same task number. And as subsequent entries are made the subform relating to that task will build up and therefore all previous entries can be viewed.

There may be a better way of doing this, but I simply want to be able to see progress relating to any particular task on the one record. NB. Any new tasks will be recorded on a new record.

I would be extremely grateful for any help in this area.

Thank you :)

 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,123,456
Messages
5,601,772
Members
414,472
Latest member
Chris_1990

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top