The reason why I have the recordsets opening and closing, was that I needed to use the various queries in order to pull the data...

All I simply want to do is use this form to view entries made by the Main form which are fed to the Access table...when the user view a record they will need to enter their name into a textbox...this will serve as a signature...I had the form calculate how many records were in the table that did not have a signature...that is where the queries came into play.

Once all records had an agent;s signature then I would alert them that there are no more records to view...this is where I am...I can move through the recordset, but I am having trouble with limiting the recordset to just records that have no agent name?? Also I noticed that when I went to the Access table to view th records from there..that each time I go to this form it is creating a new record

So I am back to square 1...

Any ideas will be appreciated...

Thank you.