Noob question - Producing an expression

[olkev]

I am very much a novice at this. I am creating a form for a dues notice in Access 2010.



In my database, if there is a dollar amount entered, then the person has paid their previous dues and is not in arrears. If the field is blank, (Null) then they are $20 in arrears.

I am having a difficult time trying to set up an expression that basically says, “ If my field "Chapter dues 2013-14" is empty (is null) then they are $20 in arrears.” I want to show arrears and current dues and calculate for a total. I cant get past the "arrears" part right now.


I think it is something close to this: =IIf[Chapter dues 2013-14]Is Null=20

But, I cannot get it to work and I don't know if I am even close.


Any help is greatly appreciated.

[June7]

Try:

=IIf(IsNull([Chapter dues 2013-14]), "$20", Null)

[olkev]

Comes back with an error saying This control has a reference to itself.

[June7]

Circular reference - give the textbox a different name, like tbxDues.

[olkev]

Bingo!!

Thanks