table limits?

[aftershokk]

Hi, I have a form where a user enters value that gets entered into a table. I only want to allow the form to allow the user to only add one record in the table. Can tables be defined to allow one record entry? The problem is they enter the value and hit the enter key and the value goes blank so they enter another value and hit enter and keep appending to this table which then causes an update qry to fail.

thanks

 

[pbaldy]

See if changing the Cycle property of the form gets you what you want.

 

[aftershokk]

thanks it did the trick, I could not remember for the life of me as I don't really use Access anymore