ID required

[matrixindicator]

For an update of a progress bar required the ID of the main-form with the event current-form. When adding a new record there is not a IDRQ already defined and he said invalid use of null. What can I do about it ? Setting a default ID ? When adding a new record the result of the progress bar should always be 0, nothing, perhaps I can use a dummy value ?

intForm = [Forms]![F1A_RQ]![IDRQ]

 

[MajP]

If I understand your question look at the NZ function (null to zero)
intForm = NZ([Forms]![F1A_RQ]![IDRQ],0)

 

[matrixindicator]

MajP, great tip, I solved it with this (and a little adaptions of other parts of my code).

I agree, I could explained it a bit better, thanks for understanding.

Dim intForm As Integer
intForm = Nz([Forms]![F1A_RQ]![IDRQ], 0)

Set rst = dbs.OpenRecordset(strSQL, dbOpenDynaset)
If intForm = 0 Then
    intCountTasks = 0
Else
    intCountTasks = rst!CountTasktitle
End If

 

[PHV]

Why open a recordset when you know you'll don't use it ?

Dim intForm As Integer
intForm = Nz(Forms!F1A_RQ!IDRQ, 0)
If intForm = 0 Then
    intCountTasks = 0
Else
    Set rst = dbs.OpenRecordset(strSQL, dbOpenDynaset)
    intCountTasks = rst!CountTasktitle
    rst.Close
    Set rst = Nothing
End If

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886