MS Access - Stop Access allowing Access To Other Records When In A Form ???

[StevenSkinner]

Hello,

I really Need some help on this one:

I have created an Access (2000) Database, and I have some forms where you can select a specific Record with the Find Function.
But once you have found that record I want the user NOT To Be Allowed to select another record in that form.
I have disabled the Records Selectors But You can still sellect the next record etc with the below:

Mouse Scroll Wheel
Page Up + Page Down Buttons
or via the Edit/Go To (Next/Previous/Last Record)

Is there any way I can stop the above being done ???? otherwise the user could input data on the wrong record !!!

Any Help would be Great !!!

[RobDog888]

You can also use something like the FilterBySelection method. This will filter your recordset down to
whatever criteria. If it is just one record then thats all the uses can see. No moving, mouse wheel, pageup buttons, etc.
Then when they are done with it they can remove the filter.

[StevenSkinner]

How do I use this FilterBySelection Method with the use of VBA Code ????

[RobDog888]

I believe you can run it by the "DoCmd.RunCommand acCmdFilterBySelection" command.

[StevenSkinner]

Thats Great - Thanks again