#Error displaying in form control

T

Ted

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?
 
F

fredg

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.
 
T

Ted

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)
 
R

Rob Oldfield

Ho hum. Can I just ask how many threads you intend starting on this issue?
 
R

Rob Oldfield

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.
 
Top