Re: Add New Record

Tech-Archive recommends: Speed Up your PC by fixing your registry

Is the form based on a table or query?
If query, open it directly.
Are you able to enter data there?
If not, you won't be able to do so in the form either.

If that's not the issue, open the form in design view.
Open the Properties box, ensuring its title says Form (so you are looking at the properties of the form, not those of a text box.)
On the Data tab, make sure you have:
Recordset Type Dynaset
Allow Additions Yes

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Herman" <Herman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D4D124DF-358C-45EE-BF3B-B0CE87F0B326@xxxxxxxxxxxxxxxx
Thanks for your reaction.
However, I need some additional help.

If I click on the button, it looks if a new record has been created, but I
cannot enter data.

"Allen Browne" wrote:

Here's a little safer version:

If Me.Dirty Then Me.Dirty = False
If Not Me.NewRecord Then RunCommand acCmdRecordsGotoNew

"Herman" <Herman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F5A1BFEB-01BB-44FE-842A-EBBDA4781156@xxxxxxxxxxxxxxxx
>I converted a database from Access 97 to Access 2003.
> The button to create a new record doesn't work anymore.
>
> I use the following code:
>
> DoCmd.GoToRecord , , acNewRec
>
> Is additional code required?

.

Quantcast