Ask a new question

switchboard to form in datasheet view

All,

I am wondering if it is possible to use a switchboard and have it open a form in datasheet view (which is how I have designed the form)

It appears if I open the form the traditional way...... using the navigation pane it opens... in datasheet view.

However, if I try to open the same form using a switchboard it open in a traditional form view.

I can manually switch it to datasheet view but it sure would be helpful if it opened the way I had intended it to.

Thanks
Answer
Answer

If you are using the "built in" switchboard, you would need to create a VBA procedure or a macro to open the form in datasheet view and then call the procedure from the button on the switchboard.

 

The VBA would basically be

Public Function fOpenMyForm()

   DoCmd.OpenForm "NameOfForm", acFormDS

End Function

John P Spencer
Access MVP 2002-2005, 2007-2011

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated January 21, 2024 Views 1,214 Applies to: