restrict data

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
 
K

karl dewey

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

John W. Vinson

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

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!
 
C

Christina

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!
 

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