I apologize in advance if this questions is too long winded...

I have a Form (we can call it frmA).

When opening the form, I want the database to check to see if there is currently a record that has not met a certain criteria (a checkbox being unchecked). This would mean that there is currently a record that has not been completely closed.

If there is a record, that has a checkbox unchecked, i want the new record to automatically check that records checkbox and put in a few more fields of data in that previous record (e.g. closedDate, closedby, etc...)

I am planning to use the on Formopen area to put the code in, but im not sure how to have it do what i want.. any help or step in the right direction would be appreciated.

If this form will be used to navigate to other records, you should put the code on the current event of the form. The easiest thing I can think of is to use the DCount Function to determine if there are any records that match your criteria. Then if there are, execute an update query to update the records accordingly.

HTH.

thank you for the info. i will research the dcount funtion