Datasheet view issues

[rmoore]

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

[Bob Fitz]

I think your code should be:

DoCmd.OpenForm "WorkOrderUpdateF",acFormDS

[rmoore]

Thanks Bob, that solved it

[Bob Fitz]

Thanks Bob, that solved it

You're welcome. Always glad to help if I can