I have a form I want to create to enter data.


It will be for a fairly simple table where data is entered monthly.
I want the form to populate with data if the month the user selects has already been entered.

For instance, if the select July 2010 and the data has not been entered yet, it simply shows blank fields like the example below, but if the select June 2010 from the drop down and data has been entered, then it lists the data entered, and it can be edited.

My goal is to create a simple data entry form that prevents duplicate entry of data, yet allows previously entered data to be entered.

Here is a mock up of the form:
Attachment 1545

Thanks, Cliff