Ok...round two. This one should be easier than the last one.
I got the status field to update depending on the date fields. Now I need the date field to autoupdate when a checkbox is checked. I have two queries, one adds the date if the box is checked, and the second removes it if they change their minds and uncheck the box.
K dont laugh but Im not sure where to put that text. How do I put the code in there? I have seen the vb on buttons through expressions but I am not sure how to put it in a text box that contains data and secondly how do I get that info to a query or table for reporting purposes?
I put it in under the Onclick for the checkbox and this works great. You are amazing. Writing code seems a heck of a lot easier than the macros. I have new vb book I plan to sit down with tonight. Thanks again.