Simple Macro help for adding a record in a form

[TCrank]

I tried to create a simple macro to assign to a button that would pop up an entry form to add a record and I get an error message.

Here are the steps I used to record the macro:
1) Go to a cell in the table
2) Select "Data", from the menu bar
3) Select "Form"
4) Click on "New" in the data form

Then end the macro.

When running the macro I get an error message: Run-Time '1004':
ShowDataForm method of worksheet class failed

Appreciate any help you could give me on creating the macro or the code to produce the data entry form for the user and present a blank record to type in the data.
Thanks!

 

[mjrofra]

check this, may give you some clues:

http://support.microsoft.com/?scid=kb;en-us;110462&x=9&y=8