How do I freeze the form with a record on it?

  • Thread starter Thread starter Morris
  • Start date Start date
M

Morris

Ive got formA with a listbox containing 47 rows, each of which
obviously corresponds to a record in the table. On OnClick I bring up
another form to tyhe screen with all the data split to different lables
and textboxes. Now when user rolls the mouse wheel he's able to view
all of the records, not just the one he chose from the list, how can I
disable that?

I tried changing the property of the form - Cycle - from "All records"
to "Current Record" but it doesn't seem to work :(

Please help :)

Regards, Morris
 
Hi Morris,

Do a google search for MouseHook.dll and use the one appropriate for your
version of access.

TonyT..
 
Morris said:
Ive got formA with a listbox containing 47 rows, each of which
obviously corresponds to a record in the table. On OnClick I bring up
another form to tyhe screen with all the data split to different lables
and textboxes. Now when user rolls the mouse wheel he's able to view
all of the records, not just the one he chose from the list, how can I
disable that?

I tried changing the property of the form - Cycle - from "All records"
to "Current Record" but it doesn't seem to work :(
Click to expand...


Well, that can be done if really necessary, but why not just
filter the form to the single record you want to see? This
is easily done by using the OpenForm method's WhereCondition
argument. The OpenForm line in the click event would be
something like:

DoCmd.OpenForm "theform", , , "[pk field] = " & Me.listbox
 
Back
Top