Calculated fields in continuous forms (1 Viewer)

[bbwolff]

i have a continues form that lists all my active items and I'd like to use it to quickly check if they have all the data inserted, ie entries in each separate table. it looks like this

I perform a simple check on form load
chk = DCount("[phID]", "preh", "[phbID] = " & Me.tID) where me.tid is the item ID and this gives me 0 or 1 and writes ok, or missing into the appropriate box.
Problem is it tkaes value for the first item and repeats it for eah other, so I get ok or missing throughout the continuos form.

How can i force a check for each line?

 

[Ranman256]

If all the calculated fields are in your query , use them instead of DCOUNT fucntions...

in the query make the field : 2*[radius] * 3.14 as Circum

if you need to do lookups in another table , use a query and joined tables.
if you still cant get what you need, THEN use the DLOOKUP