switchboard query

[jalldridge]

Hi guys,

I've got a form that shows the result of a query in datasheet mode.

However if I use a switchboard to open the form (and hence run the query) the results aren't in datasheet mode but in column mode.

How do I get the this query to display in datsheet view?

Thanks

 

[jalldridge]

Just found this and it appear to do the job:

http://www.access-programmers.co.uk/forums/showthread.php?t=74469&highlight=switchboard

If anybody has any other suggestions be pleased to hear them!!!

 

[Pat Hartman]

This is one of the few cases where I create a macro. Although in some of my databases I have modified the switchboard to perform this functionality by itself. Of course, once you add another action type to the switchboard, you can no longer use the manager. You need to work directly in the Switchboard Items table or write your own wizard.