Closed records appearing in Forms

[Ligaya]

Hello,

I am at my wit's end and cannot seem to find a solution to the problem. I have a form which is used for entering data on issues and problems in my work. When the issue or problem has been resolved, we click on a "closed" radio button. There are no scroll bars or navigation bars on the form, yet when one moves the scroll button on the mouse, all the records (active and closed) show up, which should not happen as we don't want all records to be seen by all and sundry.

Could someone please point me in the right direction to stop closed forms from appearing when 'scrolled' by the mouse button? Is there a property that I have neglected to fill in?

Thank you.
Ligaya

 

[Guus2005]

How do you suppress the closed records? You could use the filter property, when you have a bound form. You probably have.

me.filter = "Closed = False"

After closing one record by clicking the checkbox on the continuous bound form, let the code perform a requery.

Enjoy!

 

[rainman89]

you can also set the record cycle to the form to current record only

 

[Ligaya]

Suppress closed records on a form

Many thanks for your suggestion, Ray. I shall give it a go.

Regards,
Ligaya

 

[Ligaya]

Guus, thank you for your input. I appreciate it.

Regards,
Ligaya