Conditional marker on subform?

  • Thread starter Thread starter Kaykayme
  • Start date Start date
K

Kaykayme

I want to show an image if the record in the continuous subform is meets a
certain condition. When the records are shown on the Single Form there is
not a problem. But when shown in a continuous subform if the first record
meets the criteria all of the other records whether they meet the criteria or
not shows the image. If the first record does not meet the criteria and
other records do the image does not display.
I tried adding a field and inserting an attachment and as an OLE object but
this did not work and I could not update this field programmatically.
Besides I would have to update each record each week when the data is
updated. This would not be practical because of the large number of records.

Any suggestions?
 
If you want to enter quarterly data for each 'member' it may gbe preferable
to use a dedicated form on a query something like

SELECT MemberId, some cols to uniquely identify the member, quarterId, the
cols you want to enter data into
FROM members
LEFT JOIN QuarterMemberInf ON members.memberId = QuarterMemberInf ..memberId
WHERE quarterId = [Forms].[TheformName].[Thecomboname]

should list all the members and data here the specific quarter is selected
and blanks where there's no data entered

Try it as free standing a query first (use a specufic querterId rather than
the form combo ref just to check it will let you enter data in rows where
it's missing

You will likely need to define the table relationships Menu > tools >
relationships.

if the query lets you enter the quartely data when missing ok then construct
the form. Put a docmd.requery on the onc-click event of the combo.
The form will then list all the members and the specific quarter data with
empty cells where it's absent.
May be appropriate to invent a 'retired' flag or similar so you can avoid
displaying past memvers.

You can use the original form for 'looking at' rather than entering the
data.
 
Back
Top