#Error displaying in form control

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

 

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

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.

 

[Guest]

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)

 

[Rob Oldfield]

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

 

[Guest]

it's called researching available options. 's there a problem with it.

 

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