Run-Time Error '94' Invalid use of Null

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Hi all,

I use the below code to print Dymo labels, the purpose is to print the
number of labels in the textbox TotalParcels.The code works fine on exsting
records. When I attempt to print a new record I get Run-Time Error '94'
Invalid use of Null The code highlights on this line >> For L = 1 To
Forms!frmScan!ScanSub.Form.Parcels

When I hover the mouse over the L it = 0
Thank you
Richar
------------------------------------------------------------------------------------------------
Private Sub Label5_Click()
Dim strWhere As String
Dim L As Long

If Me.Dirty Then
Me.Dirty = False
End If


If Me.NewRecord Then
MsgBox "Select a record to print"
Else
strWhere = "[ScanID] = " & Me.[ScanID]
End If


For L = 1 To Forms!frmScan!ScanSub.Form.Parcels
DoCmd.OpenReport "rptScanlogDymo", acViewNormal, , strWhere
Next L


DoCmd.GoToRecord , , acNewRec
Department.SetFocus

End Sub
 
Hi all,

I use the below code to print Dymo labels, the purpose is to print the
number of labels in the textbox TotalParcels.The code works fine on exsting
records. When I attempt to print a new record I get Run-Time Error '94'
Invalid use of Null The code highlights on this line >> For L = 1 To
Forms!frmScan!ScanSub.Form.Parcels
Click to expand...

You'll need to save the current record to disk:

If Me.Dirty Then Me.Dirty = False

will do it, before you'll be able to loop through the records.
 
John W. Vinson said:
You'll need to save the current record to disk:

If Me.Dirty Then Me.Dirty = False

will do it, before you'll be able to loop through the records.
Click to expand...


Thanks John for the reply. I am still unsure on the direction I need to go.
I thought the me.dirty=false line saved the record? And if there is a value
in the Parcels textbox I shouldn't get an error.

Richard
 
Hi all,

I use the below code to print Dymo labels, the purpose is to print the
number of labels in the textbox TotalParcels.The code works fine on exsting
records. When I attempt to print a new record I get Run-Time Error '94'
Invalid use of Null The code highlights on this line >> For L = 1 To
Forms!frmScan!ScanSub.Form.Parcels

When I hover the mouse over the L it = 0
Thank you
Richard
------------------------------------------------------------------------------------------------
Private Sub Label5_Click()
Dim strWhere As String
Dim L As Long

If Me.Dirty Then
Me.Dirty = False
End If


If Me.NewRecord Then
MsgBox "Select a record to print"
Else
strWhere = "[ScanID] = " & Me.[ScanID]
End If


For L = 1 To Forms!frmScan!ScanSub.Form.Parcels
DoCmd.OpenReport "rptScanlogDymo", acViewNormal, , strWhere
Next L


DoCmd.GoToRecord , , acNewRec
Department.SetFocus

End Sub
Click to expand...

Hrm. Apologies for the hasty answer previously!

What's in Forms!frmScan!ScanSub.Form.Parcels? Is the subform open and
populated? You'll get this error if that control is NULL or does not exist.
 
Hrm. Apologies for the hasty answer previously!
What's in Forms!frmScan!ScanSub.Form.Parcels? Is the subform open and
populated? You'll get this error if that control is NULL or does not exist.
Click to expand...

Yes the subform is open and parcels is populated with a number

Richard
 
Yes the subform is open and parcels is populated with a number

Richard
Click to expand...

If you step through the code in debug mode, what's in Parcel? What's in
strWhere?
 
:



parcels = 0
Click to expand...

Well, that's the problem obviously. "Box 1 of 0"...
strWhere = 11

Although I do have a value in the subform.. (parcels)
Click to expand...

Without more debugging than I can do at this distance I don't know what to
suggest. It's clearly not reading what you intend it to read as the loop
limit.
 
I think I may have figured this one out! I was referencing the wrong control
opps!
I referenced a bound control on the sub form called "parcels" instead of a
unbound control on the main form called "TotalParcels" oh my.

;P
 
Back
Top