Stay on current record

[MadMaxx]

I have a user maintenance screen that displays all their information and allows them to change their passwords. How can I get it so they stay on there record only and not go into other records.

What's happening now is that when they tab through all the fields it goes to the next record. How so I prevent that?

 

[dcx693]

Specificallly set the form's recordsource to display only the record for that user. Do that by using a query as the form's recordsource, either a stored query or a SQL statement.

Using a bookmark to go to a specific record, the Find command or a form filter will not hide the other records.

 

[Mile-O]

Also, set the Cycle to Current Record as an extra precaution.

 

[dcx693]

Good idea Mile!

 

[MadMaxx]

Thanx anyways guys. But they way I did was used the BuildCriteria Function to create a filter that matched with the id of the record and turned off athe AllowAdditions property.

cheers

 

[dcx693]

MadMaxx, that's great if it works for you. It's just that when a form has been filtered, you can easily remove the filter and see other records. Since this involves user passwords, you might want to consider something a bit more bulletproof.

 

[MadMaxx]

Thanx for the tip but since this system involves passwords when i am finished it it will be an mde file that doesn't show the database window and also the menu won't be shown. This should take out the ability to edit the filters. Let me know.

 

[MadMaxx]

forgot one thing aswell. When the user maintenance screen is displayed therre are no passwords showing. They can change their password only if the password they enter in the old password field matches the one in the db will it allow it.

 

[dcx693]

In Access XP, I can right-click the form and choose to remove the filter.

 

[MadMaxx]

Actually just worked out a way around.

In my startup options uncheck everything and select which form I want to start. This gets rid of the right clicking. Also I created 2 macros t display blank menus in replace of the Access menus. Thus not allowing the user to select Record->Remove Filter.

 

[Mile-O]

Have you disabled the Shift key too stop folk getting in that way?

 

[MadMaxx]

Mile I posted a new topic with disabling the shift key

 

[Mile-O]

I know - glad you took the suggestion.

 

[MadMaxx]

It was in my mind to begin with just had to get it to work.