What do I need to look for?

[MCantu]

Hello- it’s hard to find something in the forum if you don’t know what to look for.

I need dlookup in reserve

I have a user check out the data before they run a report. I can’t automate it because they must come to a decision on how the data must be fixed. Each situation is unique

I have a table:


Tblcheck


Check list (text) Done ( yes/ no)
------------------------------------------------
Correct hours Yes
Backward entries Yes
Overlapping entries Yes
Data Compiled No



As they go through forms- each form has a subform filtered to each entry on the tblcheck table. As they go- they check a button called “done”

The last check is “data compiled”
I have a command button that runs queries and puts together all the data so they can now run reports.

I want to put code in that when that command button is done- the last thing it does it mark “Data compiled” to “yes” so that the displayed table “tblcheck” has everything marked off- and the user knows that it’s safe to run reports.


What do I need to look for to accomplish this?

Thanks!

 

[MCantu]

Please

I'm not looking for a final answer- just a head into the right direction