Hi All, I have a problem getting a form to open in datasheet view. The default view is set to datasheet and datasheet view is allowed. It will open in datasheet view if I open it directly from the navigation pane but if I open it from a button it opens in single form. This is how i have it setup. I have a 'HomeF' form that has a button 'cmdWorkOrderManagement' when clicked 'WorkOrderManagementChoiceF' form opens as a pop up. On that form I have a button 'cmdUpdateWorkOrder' when clicked it should open 'WorkOrderUpdateF' form in datasheet view. This is the code on the event property.Private Sub cmdUpdateWorkOrder_Click() DoCmd.OpenForm "WorkOrderUpdateF", acDatasheetEnd Sub
Any help would be helpful
Test Copy.zip