intermittent form error

[lynn atkinson]

I have a fairly complex form based on a query (made from 3
tables) and containing a sub form. The subject of the form
is course information and the sub form are the people
booked on the course. I have a calculation which takes in
to account the maximum number of places available and
counts the number of participants booked on the course in
the subform, to give the number of places still available
on the course.
However, I am having some problems with this form
displaying #Name? in this calculation field when I scroll
through the records. The first few records display ok, but
when I view about the 5th or the 6th record, this error
displays (It doesnt matter what record I start with so it
isnt a corrupt record).
If I then go into design view and flip back to Form view,
the correct value comes back, until I flick through 5 or 6
records again.
Am I asking the form to do too much? The query is based on
3 tables and I am asking it to do 2 calculations in the
form, the sub form just links all the people booked on
that particular course from the table 'bookings'. Could it
be a memory thing?

can anyone help?

 

[john]

are you using dcount to do this
dcount("courseID","nameofLinkedsubform","[courseID]=
forms!childname!nameodsub!courseID")

should work i dont get any problems off it at all
usually if its memory it will tell you that

you can email me at:j#onathan.moo#re77@ntlw#orld.com
(take out the #)