Help using DLookup

[tanski811]

I need to fix my form (ie survey) so that a user can only scroll through the current page and not to another record using the mouse scroll button.

I'm having trouble using the Dlookup function.

Please help

 

[mdcory]

I took a look at your sample, and by your post and the form it looks like you just want the user to enter their responses and then the form closes, correct? The easy way around that is in hte form properties and the data tab change the "data entry" to yes. That will prevent them from seeing the previous records by using the scroll wheel.

 

[tanski811]

Data Entry set to "Yes"

It didn't work. If you open the dbase and enter your name in the First and Last name field and try to scroll down the page using the mouse it goes to the next record.

 

[mdcory]

Ooops, sorry forgot about the new record. Here, I made the form unbound and using VBA to store the records. There is probably a better way to do it, my knowledge is still pale in comparison to everyone else here, if there is someone will come along and fill you in.

 

[tanski811]

Sample Dbase

Thank you, you just saved my career

 

[mdcory]

No problem. I save my bosses career everyday. I also misspoke. I didn't make the form unbound I made the controls unbound.