Hi,
This is screenshot of my error with the code. When I click Stop to stop the macro, the datasheet view comes up how I wanted, any idea what's wrong? How can I get it to stop the error and continue with the datasheetview?
Code:Private Sub Form_Load() 'get access and edit mode status from main form Me.AllowEdits = bEditMode Me.AllowDeletions = False Me.AllowAdditions = False Me.[txtProjectNumber].ColumnOrder = 1 Me.[txtQPNumber].ColumnOrder = 2 Me.[txtWorkOrder].ColumnOrder = 3 Me.[txtProject Title].ColumnOrder = 4 Me.[cboEstimatingAction].ColumnOrder = 5 Me.[cboEstimatePurpose].ColumnOrder = 6 Me.[cboProjectDesignPhase].ColumnOrder = 7 Me.[cboEstimateStatus].ColumnOrder = 8 Me.[Directors Action Item list].ColumnOrder = 9 Me.[dtRequestDate].ColumnOrder = 10 Me.[dtRequestedCompletion].ColumnOrder = 11 Me.[RequestByPerson].ColumnOrder = 12 Me.[cboRequestByOrganization].ColumnOrder = 13 Me.[isProgram].ColumnOrder = 14 Me.[isRelease].ColumnOrder = 15 Me.[txtProgramEstimate].ColumnOrder = 16 Me.[bProjectDeliverables].ColumnOrder = 17 Me.[bConstructabilityReview].ColumnOrder = 18 Me.[cboRegion].ColumnOrder = 19 Me.[txtScopeDescription].ColumnOrder = 20 Me.[cboScopeCategory].ColumnOrder = 21 Me.[cboBusinessUnit].ColumnOrder = 22 Me.[cboWorkType].ColumnOrder = 23 Me.[cboVoltageClass].ColumnOrder = 24 Me.[txtPreviousEstimate].ColumnOrder = 25 Me.[Priors].ColumnOrder = 26 Me.[txtStatusNotes].ColumnOrder = 27 Me.Requery Exit Sub End Sub