Is it possible to do mousewheel scrolling on an unbound form?

[Adrian1974]

In bound forms you can of course scroll through records using the mousewheel.

I have a form, let's call it frmThing, that has a listbox, lstThing, which has a table as its record source. Now when selecting an item from the listbox, table values are assigned to unbound text boxes in the form. I want to be able to click on an unbound text box, then use the mouse wheel to scroll through the records of the table like I would a bound form. Is there any way to do this?

 

[MazeWorX]

What you want makes no sense. You populate the textbox with a single record then want to scroll the record in that text box??? remember it is only populated with the one record based on your users selection in the combo and is unbound to anything else

Maybe tell everyone why you want to do this it might make more sense

HTH << MaZeWorX >> Remember amateurs built the ark - professionals built the Titanic [flush]

 

[missinglinq]

I have to agree with MaZeWorX! If you want it to behave like a bound form you need to make it a bound form! If you want to use the Listbox to move to a certain record in the recordset and then scroll thru the records from that point, that's certainly doable. But we need to know what your exact purpose is here in order to help.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[alvechurchdata]

I think you want to be able to click on a text box and then use the mousewheel to navigate - if you roll the mouse you want to move to the next record. If that's what you're after then you ought to be able to do something with the form's On Mouse Wheel event. I'm not sure how it would interact or interfere with the normal behavious of the mouse wheel though.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[missinglinq]

Normal behavior for the mousewheel in Access is to scroll thru the records. The request usually seen here and elsewhere is how to prevent this behavior!

But the OP here wants this behavior but on an unbound form, and there's no way to do that! The form has to be bound to hold multiple records! You could start out with an unbound form, then find the searched for record, then make the form bound, but what's the point in going thru a huge amount of unnecessary work, for the same end results?

You can easily use a combobox or listbox to locate and retrieve a given record, in a bound form, then scroll from there, which may or may not be the OP's intent. We need for the OP to post back to find this out.


The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!