How to set up a form with no arrow keys (to input only one record ata time)?

  • Thread starter Thread starter raylopez99
  • Start date Start date
R

raylopez99

Due to the peculiarities of my database design, I only can enter one
row (record) at one time for a particular subform.

If you try and enter more than one record, you get an error, and you
have to hit the escape key.

To avoid this hassle, I'd like to eliminate the arrows (or change the
properties of the subform) for the subform--how to do this?--so that
only one row can be written at a time for the subform.

Any ideas?

RL
 
raylopez99 said:
Due to the peculiarities of my database design, I only can enter one
row (record) at one time for a particular subform.

If you try and enter more than one record, you get an error, and you
have to hit the escape key.

To avoid this hassle, I'd like to eliminate the arrows (or change the
properties of the subform) for the subform--how to do this?--so that
only one row can be written at a time for the subform.

Any ideas?

RL
Click to expand...

Every form has a property named "Navigation Buttons". Set that to "No". Also
set the tab Cycle property to "Current Record" so that tabbing out of the last
control does not take them to a new record.
 
Every form has a property named "Navigation Buttons".  Set that to "No". Also
set the tab Cycle property to "Current Record" so that tabbing out of the last
control does not take them to a new record.
Click to expand...

Thanks, that worked.

RL
 
Back
Top