Data Form and Macro!

[Rutter]

Hey there, hope u guys/girls can help me!
Im having a problem, Im trying to add a macro to open the data form but I keep getting run time error '1004', so I click debug, and it all looks ok, can anyone help me?
My VB code looks like this
Sub adddel()
'
' adddel Macro
' Add and Delete Stock from Shop_Stock
'

'
ActiveSheet.ShowDataForm (It tell me the problem lies here!!)
End Sub

Thanx
Rutter
This message was edited by Rutter on 2002-04-24 07:20

 

[Steve Hartman]

ActiveSheet.ShowDataForm (It tell me the problem lies here!!)
End Sub

I think it should be:
NameOfYourDataForm.Show

 

[Rutter]

no I want to open the data form avalible in excel, through the options menus Data>Form

Anmore ideas mate?

 

[act13]

it's a bug, check out
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q213835
for a workaround