Only Enter One Record from Form

[JustPunkin]

Is there a way to restrict a user to only entering one record when entering data on a form.

I've removed the record selection buttons, but still run into the problem of a user hitting enter in a field and having it move to a new form. I'd like to force the user to only enter one record at a time, close the form and if they want to enter more, they'll be able to open a new form.

(opening and closing will all be done with macros and buttons)

I'm trying to limit the amount of access a user has to the data being entered.

 

[KenHigg]

One way is to not have the form bound to the table and just use an append query to create the new record...

 

[JustPunkin]

One way is to not have the form bound to the table and just use an append query to create the new record...

I think that may be exactly what I am looking for. That way they are not working live in the table, but rather adding to the table after they are done entering the data.. right?

 

[ghudson]

You can control the users behavior with some simple settings...

Set the Cycle property to Current Record.
Set the Data Entry property to Yes.
Set the Navigation Buttons property to No.
Set the Record Selectors property to No.
Make the users save the current record with a custom Save button.
Only allow new records to be created by clicking a custom New Record button.
Do not allow the user to close the form if the record is Dirty.

Why must the user close and then reopen the form just to add another record? Not a very user friendly design.

 

[KenHigg]

You can control the users behavior with some simple settings...

Set the Cycle property to Current Record.
Set the Data Entry property to Yes.
Set the Navigation Buttons property to No.
Set the Record Selectors property to No.
Make the users save the current record with a custom Save button.
Only allow new records to be created by clicking a custom New Record button.
Do not allow the user to close the form if the record is Dirty.

Why must the user close and then reopen the form just to add another record? Not a very user friendly design.

I don't think we know enough about the overall design to consider it not user friendly...

 

[missinglinq]

I'm sorry, but like ghudson, all I have to do, to know that this isn't user friendly, is look at the statement

I'd like to force the user to only enter one record at a time, close the form and if they want to enter more, they'll be able to open a new form.

 

[JustPunkin]

I'm sorry, but like ghudson, all I have to do, to know that this isn't user friendly, is look at the statement

I am not looking for criticism for the reasons behind what I am doing. I am simply doing what I was asked by the people who need this database.

Essentially, there will be very few times the user will need to enter more than one record; so I'd like to limit it to just one record at a time, and not let them have access to the whole table.

Thanks to those that have offered solutions, I do appreciate those.

 

[ghudson]

Your welcome!

 

[boblarson]

No need to close the form between operations.

1. Set the form's DATA ENTRY property to YES.

2. In the form's After Update event put

Me.Requery

And there you go, they can only enter one record at any time and the ones they have entered are not accessible to them.