Display a Data form

**Aland2929** · 08-03-2009, 06:19 AM

Hi All,

I have a database with a few hundred records. I can display the Data Form using Excel but receive the following error when I try display the DataForm with VBA? "ShowDataForm method of Worksheet class failed"

Sub DisplayDataForm()
    Sheets("Data").Activate
    Range("A4").Select
    ActiveSheet.ShowDataForm
End Sub

Thank You

**broro183** · 08-03-2009, 07:18 AM

hi,

Have a read of this link: http://support.microsoft.com/kb/110462

hth
Rob

**Aland2929** · 08-03-2009, 09:09 AM

Thanks Rob. I have named the data "DataBase" and it now works. The problem was that my database started in row 4. I have macro buttons in rows 1 to 3.
Thanks for your help, it is much appreciated.

**broro183** · 08-03-2009, 10:27 AM

Beauty, thats the approach I'd have gone for too.

Thanks for the feedback, feel free to add to my rep by clicking on the blue scales at the top right of my post ;-)

Rob