Add New Records

[Guest]

I'm using Access 2003 and Sql 2000. I have an employee db that I'm try to
setup a form that can add new employees. On the form properties I've changed
the Data Entry to Yes but when the form opens it's blank.

I've tied several docmd's:
RunCommand acCmdRecordsGoToNew
GoToRecord,, acNewRec
GoToRecord acDataForm, "frmName", acNewRec

What do I need to do to add new records?

Thanks for the help,

Paul

 

[tina]

when you set a form's DataEntry property to Yes, the form should
automatically open to a new record, with no existing records available. if
instead you're seeing a "blank" form (no controls showing), then it sounds
like the form's Recordset is not updateable. i'm guessing that you're using
a query or a SQL statement for the form's RecordSource. open the query (or
the SQL statement, in form Design view) and see if you can add a record in
the query datasheet. if not, then the problem is the query (SQL statement)
and not the form.

hth

 

[Guest]

I found the problem. I made some changes to one of my tables and forgot to
set the primary key.

Thanks Tina

 

[tina]

you're welcome

I found the problem. I made some changes to one of my tables and forgot to
set the primary key.

Thanks Tina