If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional marker on subform?
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? |
#2
|
|||
|
|||
Conditional marker on subform?
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. "Kaykayme" wrote in message news 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? |
Thread Tools | |
Display Modes | |
|
|