Creating an "add record" form only

[|PiP|]

Hi,

I'm new to Access. Is there a way to build a "add record only" form so
that it doesn't show previous records?

Thanks

 

[Granny Spitz via AccessMonster.com]

I'm new to Access. Is there a way to build a "add record only" form so
that it doesn't show previous records?

Set the form's data entry property to yes.

 

[|PiP|]

Set the form's data entry property to yes.

When I do that, all the text boxes disappear when I load the form.

 

[Douglas J. Steele]

When I do that, all the text boxes disappear when I load the form.

That implies, then, that the underlying recordset of the form isn't
undatable. If it were updatable, you'd see one set of the text boxes, which
would allow you to add one new row at a time.

 

[Granny Spitz via AccessMonster.com]

When I do that, all the text boxes disappear when I load the form.

That means there are *no* records to display for the current filter. Please
post your form's record source and filter properties and any code in the
form's load, open and current events that affects the form's record source
and filter properties.

 

[Rick Brandt]

When I do that, all the text boxes disappear when I load the form.

That would indicate that the RecordSource of the form does not allow edits. Is
it a query with multiple tables as inputs?