Prevent moving to new record

[Cathy]

I have a form which is tied to a table. To get to the form the user does a
look-up. Once on the form the user can edit the fields on the table. I
would like the only option the user has then to be to save and close. Right
now, if they tab around they will eventually move to a new record. How can I
prevent tabbing from moving to the next row in the table?

Thank you,

 

[fredg]

I have a form which is tied to a table. To get to the form the user does a
look-up. Once on the form the user can edit the fields on the table. I
would like the only option the user has then to be to save and close. Right
now, if they tab around they will eventually move to a new record. How can I
prevent tabbing from moving to the next row in the table?

Thank you,

The form has a Cycle property. Set it to Current Record.
It's on the Form property sheet's Other tab.

 

[Jim Bunton]

You could change the form's recordsource when it is opening to refer only to
that record you want the user to be able to edit.So, the record source
includes a where clause using the id for the record identified on the
calling form


It might be preferable to use a new form for this so that the original one
(when used) still has all records when ity opens (if this is waht you want
it to do generally)

Jim Bunton

 

[Cathy]

Thanks Guys!

You could change the form's recordsource when it is opening to refer only to
that record you want the user to be able to edit.So, the record source
includes a where clause using the id for the record identified on the
calling form


It might be preferable to use a new form for this so that the original one
(when used) still has all records when ity opens (if this is waht you want
it to do generally)

Jim Bunton