Silly invalid use of NULL question 1

[mdweezer]

I've got a form with a bunch of fields, when a command button is pushed i'm assigning those fields to a bunch of variables which will then get passed as criteria for a report. However I'd like to have it so not all fields need information, whichever fields have data in them will be the only ones use for the where clauses in the report. My code is as follows

TitleValue = Title.Value
OriginatorValue = CBO_ORIGIN.Value
StatusValue = Status_Code.Value
AssignedByValue = cmb_AssignedBy.Value
AssignedTo = cmb_AssignedTo.Value
PriorityValue = Frame89.Value
GenerationDateValue = Generation_Date.Value
DueDateValue = Text213.Value
CompletedDateValue = Date_Closed.Value
AssignedDateValue = Text215.Value
DescriptionValue = Description.Value
CommentsValue = Description.Value
DispositionValue = Disposition.Value

Impressive, I know

Anyway, if any of those fields is left blank I get a invalid use of null error. Whats the easiest way to work around that error? Thanks

 

[lupins46]

TitleValue = nz(Title.Value)
do the same for all lines.

 

[mdweezer]

Worked like a charm, I knew there had to be a easy fix!