If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Datasheet form question
Hi all,
I'm having a problem with a form I've created in datasheet view. When I open the form through the 'forms' tab it works fine and displays all records in a 'table' way, but when I open the same form through the switchboard, it will not display the same way. I am able to get all records to show in the form when I open it through the switchboard by changing the form properties (changing 'Default View' to 'Continuos Views') but it's still not what I'd like to achieve. I've also tried changing the switchboard properties from both "Open Form In Add Mode" and "Open Form In Edit Mode" but neither seem to work. If anyone could offer any advice it would be greatly appreciated. Thanks! osmondb |
#2
|
|||
|
|||
Datasheet form question
For anyone else who might be having the same problem, I'm
posting my solution that I just thought of (though it's actually very simple -- I still can't figure out why I didn't think of it earlier). To ensure that any form which was created as a "datasheet" form opens in "datasheet" view in the switchboard utility (instead of just showing one record at a time) write a macro that will open the form. Be sure that when you select "OpenForm" you change the "view" property down below to "Datasheet". Then, when you create a Switchboard Item select "Run Macro" instead of "Open Form in...", this will open the form properly in datasheet view. |
Thread Tools | |
Display Modes | |
|
|