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

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: raylopez99 <raylopez99@xxxxxxxxx>
Date: Mon, 24 Dec 2007 08:14:49 -0800 (PST)

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
.

Follow-Ups:
- Re: How to set up a form with no arrow keys (to input only one record at a time)?
  - From: Rick Brandt

Prev by Date: Re: how to pull a record to a form and save it to another table
Next by Date: Re: How to set up a form with no arrow keys (to input only one record at a time)?
Previous by thread: Re: how to pull a record to a form and save it to another table
Next by thread: Re: How to set up a form with no arrow keys (to input only one record at a time)?
Index(es):
- Date
- Thread

Relevant Pages

Re: the data has been changed
... the real cause of the problem is bad database design. ... Your main form can then be bound to your master table, and your subform (you ...
(microsoft.public.access.formscoding)
Re: Scrolling through data on a subform while the labels are stati
... Apparently the key is to figure out the "exact" height height that fits the ... It took a number of trys of changing the subform ... the arrows, it will move the form by 1 set of values. ... Using the subform's scroll bar (either moving the thumb, ...
(microsoft.public.access.forms)
Re: Down Arrows in Subform Header
... also mean a lot more work, just to make the Arrows go away, rather than ... Several have forms where the main form is one record and the subform has ... the header record would have a trip ... I don't know if you can turn it off for datasheets. ...
(microsoft.public.access.forms)
Re: Scrolling through data on a subform while the labels are stationar
... The Northwind sample is a continuous subform, ... the arrows, it will move the form by 1 set of values. ... Using the subform's scroll bar (either moving the thumb, ...
(microsoft.public.access.forms)
disable button if field is empty
... the subform actually contains fields from the same table as the big ... cause when I use the arrows, it is no longer a form_load, so if the ... button was disabled because the field was empty in the first record, ...
(comp.databases.ms-access)