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

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
 
R

Rick Brandt

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

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.
 
R

raylopez99

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.

Thanks, that worked.

RL
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top