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
320
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 :)

 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Forum statistics

Threads
1,223,902
Messages
6,175,278
Members
452,629
Latest member
SahilPolekar

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
Back
Top