I am using MS Access 2002 as a quarterly data capture tool. I have built a definitional form (frmDefinition) that captures the parameters of the data points I am collecting (all manual). Within that form I have embedded a subform (sfrmStatus) into which I input the data associated with the individual definition each quarter. The selection of the reporting period is manual from a dropdown box that is populated from a table (tblPeriod) - I have consciously chosen not to code the date / timeframe into the tool.
Here's my challenge: I am trying to code the subform such that only the current quarter is can be editted at any point and the rest of the data is locked. I have created a form (frmPeriod) that contains a check box for each quarter (continuous form linked to the tblPeriod table). The check box may be selected to indicate the current quarter (chkCurrentQ). I have coded that form to only allow one quarter to be checked at any given time.
My theory was that I could run a query against tblPeriod filtering for the single item that was marked as the current quarter and that I could use that query result as the conditional criteria in an If / Then statement in the sfrmStatus subform to lock the records that were not during that quarter. I have not figured out how to reference that data though as a condition. Any help would be very appreciated, including any alternative approaches to this challenge. Thanks in advance.