根据是否收入选择收支类别
【收支计划】模块一样,在录入数据时,要根据【是否收入】来决定【类别】组合框的选择项,因此需要在窗体的加载事件中,添加限制组合框行来源的代码:
Me.MCategory.RowSource = "Select Sys_LookupList.Value " _
& "FROM Sys_LookupList " _
& "Where (((Sys_LookupList.Value) <> '') And ((Sys_LookupList.Item) = '收支类别') " _
& "And ((Sys_LookupList.Category) = '支出')) " _
& "ORDER BY Sys_LookupList.Category"
视频讲解
点击:https://m.qlchat.com/wechat/page/topic-intro?topicId=2000016644035563 (打开网页后用微信扫描登录)