Data disappearing in bound form

[ersouthard]

I have a data entry form that is bound to a table. I have the Data Entry
property set to Yes so that the person entering data can't move through all
of the records. Some of the fields in this form pull data in from another
form that the data entry person has already entered (year, week number,
month, etc). These fields have the Enabled property set to No and the Locked
property set to Yes so that the information can't be changed accidentally.
Here is my issue. When the form is open and you move the mouse wheel or
press the Page Down key, the information pulled from the other form
disappears. How can I prevent this from happening? Thanks!

 

[Linq Adams via AccessMonster.com]

I suspect it's not actually "disappearing" but rather you're moving to
another, new record. In Design View for your form try this:

Goto Properties - Other and change the Cycle Property from "All Records" to
"Current Record."

 

[John W. Vinson]

I have a data entry form that is bound to a table. I have the Data Entry
property set to Yes so that the person entering data can't move through all
of the records. Some of the fields in this form pull data in from another
form that the data entry person has already entered (year, week number,
month, etc). These fields have the Enabled property set to No and the Locked
property set to Yes so that the information can't be changed accidentally.
Here is my issue. When the form is open and you move the mouse wheel or
press the Page Down key, the information pulled from the other form
disappears. How can I prevent this from happening? Thanks!

Since the data is *not* in the other form but rather in a Table somewhere, I'd
just use DLookUp to retrieve the data from that table.

 

[ersouthard]

I tried that but it still doesn't prevent me from moving the record with the
wheel or the page down key.

I appreciate the response.

 

[Rick Brandt]

I tried that but it still doesn't prevent me from moving the record with
the wheel or the page down key.

I appreciate the response.

As for the scroll-wheel Stephen Lebans has a utility DLL that can make
that not cause record navigation.

As for the page keys, that falls into the category of "Doctor, it hurts
when I do this...".