Help with a macro that opens the data form "window"

[lelkes]

Hi all!

Unfortunately I'm a total newbie in VBA and macro, so I tried to record a macro which I want to open the data form so I can enter new data in my table....

Please Login or Register  to view this content.

but when I test the macro I get error 1004 at

Please Login or Register  to view this content.

I hope for your help with the macro.

Thanks in advance, your help is really appreciated.
/ / Peter

[HaHoBe]

Hi, lelkes,

I donīt know if the code works on a MAC but it certainly does on a PC:

Please Login or Register  to view this content.

Ciao,
Holger

[romperstomper]

Showdataform usually fails in code unless your data starts within A1:B2 or your range is named Database. Where is your table located on the sheet?

[lelkes]

thx romperstomber

Showdataform usually fails in code unless your data starts within A1:B2 or your range is named Database. Where is your table located on the sheet?

The table i located in A5:B11 - with the heather in row A

[romperstomper]

Can you move it up?

[lelkes]

Can you move it up?

I'll try tonight when I get home from work.