![]() ![]() Operations / Professional Development / Professional Enrichment So, if there are some records for acct #s 1, 2, 6, and 7 in the subform for that particular RFP main form record, then the Account_To_Be_Charged text box should say: If Account #s 1, 4, or 6 occur together in the same set of records in the subform, then "Operations" should only print once in the Account_To_Be_Charged text box. Professional Development / Division Incentive (for acct #s 2 and 8) Operations / Professional Enrichment (for acct #s 1 and 7 or 4 and 7 or 6 and 7) If there is more than one different Account number entered in the set of records in the subform for that particular RFP record displayed in the main form, then each Account's description should be strung together with slash characters in between. ![]() ![]() If there is only one Account # used then the Account_To_Be_Charged box would just display that Account's description. What I would like to do is have the text box named Account_To_Be_Charged on the main form lookup the Account_Descriptions for the Account #s entered for the records in the subform. For each RFP, I may create a number of expense records in the subform that use just one of those Account numbers or several. These numbers can be 1, 2, 4, 6, 7, or 8. For each record created in the subform, I select an Account from the Account combo box. The main form and subform are linked via a field named RFP_Number. There is a text box on RFP Entry named Account_To_Be_Charged. That subform is on a main form named RFP Entry. I have a combo box named Account on a subform named RFP Expenses subform. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |