Opening Datasheet from Code

N

Neil M

Can anyone tell me how to open a datasheet form from within coding
I am opening via a control box on one of my forms but it doesn't open as the
datasheet (it opens as a normal form)

Thanks.
 
G

Graham R Seach

Neil,

This exact same question was answered not long ago by Ofer in a post
entitled "Chage from Single Form to Data Sheet".

DoCmd.OpenForm "MainDetails", acFormDS

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Top