lock single form

[johnlute]

I've been looking around but can't find anything on this. I have a
subform in single form view with navigation buttons turned off because
the structure is a one-to-one relationship with the main form's parent
record.

The problem is that the subform will scroll to a blank record should
the mouse wheel be rolled while the cursor is in any of the subform's
controls. I want to eliminate this and "lock" the subform.

I've tried changing some of the subform properties that I thought
might remedy this but can't find the right one.

Is there one or does this require code?

Thanks for you help!

 

[Arvin Meyer [MVP]]

In the subform's property sheet set Allow Additions to No.

 

[johnlute]

Hi, Arvin. Thanks for the response. I was hoping it would be that easy
however when I do that then the subform displays as a blank, white
area.

 

[Arvin Meyer [MVP]]

You'll need to resize the form for the number of records. If you see a blank
white area it means that there is no record to fill that space. Check out
the SelHeight Property in the help files. I'm not sure I'd resize the
subform because it will jump in size from record to record on the main form.
You may want to just set it for the height of 2 records (or even 1) and use
the scroll bar.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hi, Arvin. Thanks for the response. I was hoping it would be that easy
however when I do that then the subform displays as a blank, white
area.

 

[johnlute]

Hi, Arvin. We may be on different pages. My form is single form view
and you seem to be talking about a datasheet view...?

 

[johnlute]

Hi, Vandal.

I'm hoping that it can be done via a form property as I have LOTS and
LOTS of subforms throughout my application. I know I only mentioned
one here but that was for the sake of simplicity. I'd hate to have to
go through my entire app and add code to each subform's current event
IF there's a form property that can do it.

Why just limit yourself when you open up the properties. There are many
properties which you can try to control the form condition.

Instead of what Arvin suggested, Have you tried to use the current event of
the subform to evaluate the condition which you want to display?

Hi, Arvin. We may be on different pages. My form is single form view
and you seem to be talking about a datasheet view...?

You'll need to resize the form for the number of records. If you see ablank
white area it means that there is no record to fill that space. Check out

[quoted text clipped - 39 lines]

- Show quoted text -

 

[Arvin Meyer [MVP]]

OK, so what you need to do is control how the mouse wheel works. Try this:

http://www.lebans.com/mousewheelonoff.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Hi, Arvin. We may be on different pages. My form is single form view
and you seem to be talking about a datasheet view...?

 

[johnlute]

Thanks, Arvin!

OK, so what you need to do is control how the mouse wheel works. Try this:

http://www.lebans.com/mousewheelonoff.htm
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com


Hi, Arvin. We may be on different pages. My form is single form view
and you seem to be talking about a datasheet view...?







- Show quoted text -