Checkbox to populate one table to another

[glasgowlad1999]

Hi Guys,



I wondering if you can give me your thoughts on the best way to do this.

I have data that is submitted from one office to another.

Lets say the 1st request is for 4 times = 1 x 15 mins

Dr. A askes that Dr. B review it.

Dr. B says it should be 3 times = 1 x 15 mins

Dr. A then has the final choice. To take the 1st request, take Dr. B's thoughts or have the final say and could say 1 time = 1 x 15 mins

On my form I want to make it as simple as possible for my staff.

On the update page it pulls the date of the 1st request, I then have 2 other sections in that form for Dr A and Dr B.

Would it be best to have a checkbox to fill Dr. A's final say, if he thinks 1st request is approved. And if so, how do i get the checkbox to populate another table.

Thanks.

[ajetrumpet]

to populate a table from a form, or update one, you need to execute a docmd.runsql command in vba code.