Re: Subform cycling

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kim (anonymous_at_discussions.microsoft.com)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 12:12:17 -0700

Would that method allow for a user to later edit the record
with the same effect?

>-----Original Message-----
>"Kim" <anonymous@discussions.microsoft.com> wrote in
message
>news:1c60201c45231$65f051a0$a001280a@phx.gbl
>> I have a button on a form (i'll call it MAIN) that
opens a
>> filtered
>> form with a subform. They work well, but the problem I
run
>> into is
>> when the person uses the scroll-wheel on the mouse, it
>> cycles the
>> records on the subform.
>> This can wind up with having 2 or 3 records with the
same
>> or similar
>> information, because the user thinks the data has
>> disappeared and
>> re-enters it.
>>
>> Is there a way to get the record(s) to remain static,
>> regardless?
>> Since only one record should be filled out for each of
the
>> MAIN
>> records, there really is no need to cycle the filtered
>> records at all.
>>
>> thanks in advance
>
>I can think of a couple of options.
>
>1. You can use Stephen Lebans' MouseHook DLL to turn off
the mouse
>wheel. It's available from this link:
>
> http://www.lebans.com/mousewheelonoff.htm
>
>2. You add code to the subform so that it turns off its
own
>AllowAdditions property as soon as a record has been
added. That way,
>the users can't scroll to a new record after creating the
first one. If
>you want to pursue this approach, I have sample code to
do it tucked
>away somewhere.
>
>--
>Dirk Goldgar, MS Access MVP
>www.datagnostics.com
>
>(please reply to the newsgroup)
>
>
>.
>

Quantcast