restrict data

  • Thread starter Thread starter Christina
  • Start date Start date
C

Christina

Is there a way to restrict data entry into a table via a form to one entry.
I want user to be able to change a date and amount monthly, but not allow the
table to have more than one entry.

Thanks
 
Donno about table but you can use unbound form with unbound text boxes and
have event or macro to Set Value default from the entry.
In other words when an entry is made in the text box the event/macro sets
that value as default for the text box. When form is opened next time it
display the default.
Then use the value from the form-textbox as you would table-field.
 
Is there a way to restrict data entry into a table via a form to one entry.
I want user to be able to change a date and amount monthly, but not allow the
table to have more than one entry.

Thanks
Click to expand...

Add a Number field to the table; make it the Primary Key (so each value can
occur only once), and give the field a Validation Rule

=1

so that 1 is the only value that can occur. Of course you need to fill this
with 1 when you first open the table!
 
Thanks very much.

John W. Vinson said:
Add a Number field to the table; make it the Primary Key (so each value can
occur only once), and give the field a Validation Rule

=1

so that 1 is the only value that can occur. Of course you need to fill this
with 1 when you first open the table!
Click to expand...
 
Back
Top