Forms collections

[blad3runn69]

Howto iterate through a form collection to check if the record the user wants to open isn't already open in a form and if record is already open then goto the form displaying this record?

builtin ms-access record edit locking kinda works (if user opens multiple form instances of the same record ms access will throw a readonly error or lock one of the forms), however it would be great if there was a way to just goto the record if it is already open in form.


Thank you for your help

[FishVal]

Hi, there.

If your code so far looks like taht ADezii has suggested you in multiple instances of a form - selected records ms access 97 thread - multiple instances of the same form class each filtered to display one record, then the solution will be quite obvious and simple.

Just iterate through the collection checking a value of the control bound to the table PK field and activate the form satisfying given criteria.

Kind regards,
Fish

[blad3runn69]

Thankyou FishVal muchly appreciated.

[blad3runn69]

seriously thankyou FishVal, if you had not put the solution so eloquently it wouldn't have clicked... :)