#Error displaying in form control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i've looked (thus far) in vain for a meaningful explanation of what is behind
this -and- what to do about it.

any experienced hands out there?
 
i've looked (thus far) in vain for a meaningful explanation of what is behind
this -and- what to do about it.

any experienced hands out there?
Click to expand...

Could be several things.
1) The name of the control is the same as the name of a field used in
it's control source expression.
2) The name of a field in the control source expression is
miss-spelled.
3) The Control source expression is a circular reference.
etc.
I suggest you give a bit more information if it's not one of the
above.

Some where in Access help there is a more or less full list of the
causes of the #error error... if you can find it.
 
hi fredg,

the control is a combobox (but i suppose it could be a textbox) with the
name/control source dubbed "Lesion Number"! for my purposes the most
important property value is

=Nz(DMax("[Lesion Number]","[Lesions: Non-Target]","[Patient Number] = " &
[Forms]![RECIST Disease Evaluation: Nontarget Lesions]![Patient
Number]),0)+1

because i want this control to default to the value '1' if there are no
other records for the (filtered value of) Patient Number and to 1 more than
the maximum value of the incrementally numbered sequence of "Lesion Number"
values (1,2,3,....,12)
 
It's also called "beating yourself around the head doing it the wrong way".
Nothing wrong with that at all if that's what you want to do.
 
Back
Top