Need help with the Control Source usage for a text box

[Pack10]

I have a date field which won't always have a value. Upon receiving info, the user checks a field and the date gets filled in and saved to the table. We have a split form which displays that field from the table.
In the control source for that field
I am trying to use this statement...

=IIf(Not (IsNull([Shot_Clock])),BusinessDays([Shot_Clock],Now()),0)

I get #Error in the split form, but if i use it in a query ...it works fine.

 

[SkipVought]

Hi,

Please post MS Access questions in one of the MANY MS Access forums like forum702.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Pack10]

I Figured this out. It was my mistake....