How to loop through all the records on a continuous form.

[PSSMargaret]

Hello all,

My database has a continuous subform with the code below in an OnCurrent event. It's only working for the first record. How do I make it check all of the records in the form making one command button visible if the file exists and a different one visible if the file doesn't exist for each record? I have the same code on a single form and it works correctly. Any assistance would be greatly appreciated.

Please Login or Register  to view this content.

[PSSMargaret]

Since I have not received any replies to my post, I have posted on another forum (link below). I would delete this, but cannot locate a delete function.

http://www.access-programmers.co.uk/...48#post1496648

Margaret

[alansidman]

Margaret,
thank you for letting us know that you have posted elsewhere. It is common forum courtesy, however, to post a link to the other thread. Here is a link to read on why we and other forums ask that.

http://www.excelguru.ca/content.php?184