问题描述
Hello Everyone
我有tblSales，其中包含CustomerID，Address1，Address2，Town，County，Postcode，Phone，DateOfVisit Fields和Paid chkbox。我有与mblSales链接的frmNewSales。
我要做的是： - 当用户在邮政编码字段中输入邮政编码并远离字段时。我希望OnLostFocus事件搜索tblSales以查找具有该邮政编码的任何记录，如果DateOfVisit超过30天并且未选中付费，它将显示msgbox未结余额
希望这是有道理的
问候
Wayne
Hello Everyone
I have tblSales Which has CustomerID, Address1, Address2, Town, County, Postcode, Phone, DateOfVisit Fields and Paid chkbox. I have frmNewSales which is linked to tblSales.
What i am trying to do is:- when a user enters a Postcode into the postcode field and tabs away from the field. I want the OnLostFocus event to search tblSales to find any records with that postcode and if the DateOfVisit is over 30 days and Paid is unchecked it will show a msgbox "Outstanding Balance"
Hope this makes sense
Regards
Wayne
推荐答案
这篇关于表格从LostFocus搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！