I am having trouble with this. I have a table that contains a column named "month_year". I have pre-filled the column with dates, ie 01/01/03, 02/01/03, 03/01/03...and so on. I have a form named "frmMetrics" that contains a field named "Period" that displays the date in a MMM YYYY format when the form is opened. The form will be used by some staff to input 8 different systme statistics every month. What I want to happen is that when the form is opened, the only record displayed should be the record with the date prior to this month. In other words, if the user opens the form in March, he will be presented with the February date record. He will not be able to enter in the March stats until April and so on.
Seems simple, but I don't know if I should populate the form by a query or if this needs to be done in a module or what the code would be to accomplish this. Any assistance is greatly appreciated.
Seems simple, but I don't know if I should populate the form by a query or if this needs to be done in a module or what the code would be to accomplish this. Any assistance is greatly appreciated.