forms, how to limit the access to the first record only

[Guest]

Hi,

wow, what a usefull forum, thanks for the previous reply, i had my data laid
out in columns rather than in rows, stupid, historical reasons.

now, how do i limit the access of a form to just one record ?
or remove the arrows bottom left hand corner?

thanks

 

[Chris L.]

Hi,

wow, what a usefull forum, thanks for the previous reply, i had my data laid
out in columns rather than in rows, stupid, historical reasons.

now, how do i limit the access of a form to just one record ?
or remove the arrows bottom left hand corner?

thanks

I'd go for an unbound form, (displaying, locking and updating the
record values programatically) but maybe it would be safer to look for
an event that can cancel the record navigation. See the "properties"
dialog, "events" tab. I know the "Current" event fires whenever a
record becomes current, but you'd have to check if you can: a) return
to the previous record, b) avoid the new record's values to be shown
on screen.

Kind regards

 

[Guest]

Open the form in design view, click on menu VIEW - Properties.Set Default View to Form View and set Allow Datasheet View to No.
Set Navigation Buttons to No.

 

[Guest]

I'm not sure why you would want to create a situation where a user has no
ability to move through recoprds, however;

If you open the properties sheet for your form you'll find an option called
"navigation buttons". Set this to no, and the the arrows at the bottom left
of your form will dissappear.