only adds

[Bill H.]

How can I set a form so that only additions to the table can be made, and
only one record (the current one) shows?

IOW, the form will be used for entering data only.

Thx.

 

[missinglinq via AccessMonster.com]

Goto the From's Properties Box then -> Data.

Set Allow Additions to YES
Set Data Entry to YES

How can I set a form so that only additions to the table can be made, and
only one record (the current one) shows?

IOW, the form will be used for entering data only.

Thx.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[missinglinq via AccessMonster.com]

Form's Property Box! Sorry!

Goto the From's Properties Box then -> Data.

Set Allow Additions to YES
Set Data Entry to YES

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[Bill H.]

However, I can still go back and see/edit other records that have just been
entered in the same session.

I'd like this to be a "one record" form where after the current record's
data is entered, it can't be viewed again.