Hi
I want an image to be visible if the event is fully booked I an unbound
control on the page that calculates the number of spaces called [number of
spaces] it calculates it using;
=[AvailableSpaces]-IIf([Events
Subform].[Form].[RecordsetClone].[RecordCount]=0,0,[Events
Subform].[Form]![Total Attendees])
This works and has for years, to make the image visible I put the
following
code:
into the Form on current event:
If Nz(Me.[Spaces Remaining]) = 0 Then
Me.Image235.Visible = False
Else
Me.Image235.Visible = True
End If
The image is always visible on every record, now I may have made a mistake
on the code because I normally do, but I have also noticed that when a
record
loads the control [Spaces Remaining] has a value briefly before becoming 0
like its doing the calculation on the after the form is loaded
Can anyone help
thanks
Phil
